[PHP-DB] Efficien search queries

I have simple db wik names, links and short (less then 1000 chars) descriptions. I do offer a search (with the select like %variable% method) but it seems to be very dumb, on single phrases it goes fine on combined it it very bad. Is there a way (link, advice) to spicy it up a bit so the user

Re: [PHP-DB] Efficien search queries

hi do you use OR and AND ? select * from table where pasta like %spagetti% or pasta like %macaroni% ? eat pasta type fasta a écrit : I have simple db wik names, links and short (less then 1000 chars) descriptions. I do offer a search (with the select like %variable% method) but it seems