List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 27 1999 2:08am
Subject:Re: WHERE on all fields?
View as plain text  
At 2:46 PM -0500 9/26/99, Richard McLean wrote:
>Hi All,
>
>
>I'm setting up a search page and would like to be able to search by
>particular fields and also search all fields by keyword. The first
>part I'm right with, but with the keyword search, is the a way to
>specify
>
>WHERE **all columns** ='$keyword'
>
>in a SELECT statement?

No.

You'll have to construct a long WHERE with lots of clauses OR'ed together.

--
Paul DuBois, paul@stripped
Thread
WHERE on all fields?Richard McLean26 Sep
  • Re: WHERE on all fields?Michael Josephson26 Sep
  • Re: WHERE on all fields?Paul DuBois27 Sep
    • Re: WHERE on all fields?Aleksandar Ivanisevic28 Sep