hi everyone,
I'm writing the code to make my mysql database searchable. I can search two
columns, but I seem to have problems when I try to search three.
In the SELECT statement, this WHERE statement works: WHERE column1 OR
column2 LIKE '%$search%' AND...
This WHERE statement doesn't work:
Try break up the query, like:
WHERE (column1 LIKE '%$search%' OR column2 LIKE '%$search%' OR column3 LIKE
'%$search%') AND ...
Tony S. Wu
Matthew K. Gold at [EMAIL PROTECTED] wrote:
hi everyone,
I'm writing the code to make my mysql database searchable. I can search two
columns, but I
Great--it works now. Thanks very much, Tony. I appreciate your help.
best,
Matt
- Original Message -
From: Tony [EMAIL PROTECTED]
To: Matthew K. Gold [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 22, 2002 1:01 AM
Subject: Re: [PHP-DB] search syntax
Try break up the query