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
>> bo
Your query reads: "SELECT * FROM books WHERE title LIKE '%php%' AND NOT
title LIKE '%perl%'" whereas it has to be "... AND title NOT LIKE '%perl%';"
I think you need to make some changes in your PHP code for the in the case
block for "-" .
Gurhan
-Original Message-
From: Jonathan David
Shouldn't the NOT be right before the LIKE:
SELECT * FROM books WHERE title LIKE '%php%' AND title NOT LIKE '%perl%'
Duncan
--
Duncan Salada | Titan | www.titan.com/testeval
Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216
> -Original Message-
> From: Jonathan Davi
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', bu
