MySQL query question

[Anon]

Hi

I want to perform a search of a MySQL database, but with a difference. Instead of using the WHERE clause such as "WHERE this_field=this text" I want to do something such as "WHERE this_field CONTAINS this text".

Is it possible to search fields like this, or does it have to be an absolute match?

[Anon]

hi andrew,

try
"WHERE this_field LIKE '%thistext%' "

% matches any characters

hth
chris

[Anon]

Hi Chris

Thanks very much, that worked a treat!

Best Regards

Andrew.