At 12:34 -0400 4/25/02, denonymous wrote: >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.
or: NOT (title LIKE '%perl%') > > >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
