Forum Moderators: coopster
SELECT * FROM `table` WHERE `field` LIKE '%search%'
that gives you all rows where `field` contains 'search'?
Or is 'search' (the search string) meant to be itself coming from the DB. In that case you'd need to do a query to retrieve the search string first, then apply it to a second query like the one above.
Or have I really not understood your question?
Cheers,
Cook