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 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 can get > more out of it each time. > > Thanks in advance. > > R> > > ________________________--__-______-______________ > eat pasta > type fasta > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- Marius Ursache (3563 || 3494) \|/ ____ \|/ "@'/ ,. \`@" /_| \__/ |_\ \__U_/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php