Php - mysql_query

[smurf22]

Im creating a search function for this download database and i want it to be able to select downloads for the database if the text entered is like whats set in the database or similiar. I've done this before by selecting all the downloads from the database and then looping and checking them with stristr() but if there are lots of downloads in the database then its going to take a crap load of the resources doing that so i was wondering if anyone knew of a way to do it actually in the query like "SELECT * FROM tbl WHERE text ISLIKE text" or something like that....if that makes sense

thanks
mike

 

[Peter]

mysql can use wildcards so your like would be like '%test%'

this would match the following:-

test
testing
atest
atesting


etc

 

[smurf22]

ahhhh thanks alot i'll try that now

EDIT: got it working thanks alot! rep added

 

[Peter]

no problem glad to have helped