List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 26 2002 12:52am
Subject:Re: Not Liked!
View as plain text  
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

Thread
Not Liked!Jonathan David Edwin Wright25 Apr
  • Re: Not Liked!denonymous25 Apr
    • Re: Not Liked!Paul DuBois26 Apr
  • RE: Not Liked!Gurhan Ozen25 Apr
RE: Not Liked!Duncan Salada25 Apr
  • regexp mis-spelling, similarDan Harrington25 Apr