Fwd: Re: [PHP] Search all data in database

Date: Tue, 11 Mar 2003 18:18:37 +0100 To: Mike Tuller <php@ce.anoka.k12.mn.us> From: Chris Hayes <chayes@antenna.nl> Subject: Re: [PHP] Search all data in database At 17:51 11-3-03, you wrote:

I am wanting to add a simple search field where you enter your search and it searches the whole database, not just one column. It would be easy for one column ( SELECT * FROM clients WHERE first_name = '$first_name';) but how do I search the whole table? Do I have to search each column one by one or is there an easier, more efficient way of doing this?

I don't want to be unfriendly but could you please try to solve problems yourself before asking?

Altavista: [mysql query tutorial]               ->      13,871 results
Google: [mysql query tutorial]          ->      52,700 results
Mamma.com:[mysql query tutorial]        ->      54 results

thanks, Chris