At 12:34 -0400 4/25/02, denonymous wrote:
>From: "Jonathan David Edwin Wright" <j.d.e.wright@stripped>
>> 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,