Search (PHP/MySql)

[Anon]

hi,

i want to perform a search on my private site. You can search for certin articles such as Tutorials, Homework and school related stuff.

I'm using mysql as my db engine and i have a tablem with 2 columns. the first one is "aid" and the second one is "description". Now i want that the sql query (or something that works) looks in the decription column for the searched word. (eg. German Homework) and returns me the id (or the ids if many results were found). I solve this problem using regular expressions, but i heard there is a way to make this with a special SQL command. (as i can remember it was something like "LIKE".)

Could anyone tell me how to perform that kind of search for the given example with the 2 colums ?

would be glad if someone could help me with that ...

thanks in advance

al

[Anon]

hmm you mean like

"WHERE (message LIKE '%$srchtxt%' OR subject LIKE '%$srchtxt%') AND ..."

where $srchtxt is the string you want to search