searching

[Anon]

hi,

i'm currently constructing a search engine, basically for a bit of a challenge. however, i have a problem in trying to work out how to implement a search on keywords in a mysql database. writing the code is no problem; i just don't know how i should go about it. ok, here's my problem: if i extract keywords from a webpage, implode() them, then put them in my database, i'll get a nice string. however, if i then want to do a keyword search on the database, presumably i have to explode() all these strings in every single database entry. but this is gonna take ages!! anybody got any ideas how i can go about searching for the keywords in the database? thanx

[Anon]

i've built several search engines but all varied in complexity.

If you want a simple search try something like:

$query = "select * from suchAndsuch where this like '%$search%'";