Using multiple instances of LIKE with wildcards

[DJM]

I am trying to use multiple instances of "LIKE" with wildcards in a query. I have tried this all sorts of ways but just can't get the syntax right.

This is what I am trying to do, so that $match will be selected from the start, middle or end of a record:

SELECT * FROM $TableName WHERE (a_field OR another_field) LIKE '%$match%' OR '%$match' OR '$match%'

Any help greatly appreciated.

[kevinsequeira]

SELECT * FROM $TableName WHERE a_field LIKE '%$match%' OR another_field LIKE '%$match%'

'%$match%' will pickup '%$match' and '$match%'

reg
kevin

[DJM]

Brilliant! Works perfectly. Thanks very much.