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,
>
>--
>denonymous
>www.coldcircuit.net
>http://24.91.199.33
