[RESOLVED] Use LIKE with IN() ?

[partypete]

Hello all,

Just wondering if there is a way to do this:

SELECT image_oname, image_mname
FROM images
WHERE image_oname LIKE '%value%' OR image_mname LIKE '%value%'

But using IN() instead like this:

SELECT image_oname, image_mname
FROM images
WHERE '%value%' IN (image_oname,image_mname)

Using IN() works fine if you're looking for an exact match 'value' but I don't know how to use '%value%' LIKE with IN().

Something like(obviously not correct...):

SELECT image_oname, image_mname
FROM images
WHERE '%value%' LIKE IN (image_oname,image_mname)

Any help appreciated as always!

Thanks,
Peter

[Lars_Berg]

There is no alternative, you have to write as in your first example.

[partypete]

Darn!! It would have been pretty cool if it was possible. Could have really shortened some queries when looking for a value in many columns.

Thanks,
Peter