From: "Jonathan David Edwin Wright" <[EMAIL PROTECTED]> > Which turns '+php -perl' into: > > SELECT * FROM books WHERE title LIKE '%php%' AND NOT title LIKE '%perl%' > > The problem I get is that the query doesn't seam to work. One of the > books in the table is 'Professional PHP Programming', but, while 'php' > will pick it up, and 'php perl' as well, 'php -perl' won't! > > Surly it should work! :-S
Your NOT terminology is wrong -- if you can get it to say "title NOT LIKE" instead of "NOT title LIKE" you should be all set. Hope this helps, -- denonymous www.coldcircuit.net http://24.91.199.33 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
