Re: multiple finder
| From: | Jason Gerfen | Date: | Mon, 29 Jun 2009 15:27:33 +0000 |
| Subject: | Re: multiple finder | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46253@lists.php.net to get a copy of this message | ||
Emiliano Boragina wrote:
Hi, I must do e finder for properties... I know do a simple search but not a search like this with more one possibility, with all or some fields full... How do it? Thanks a lotExample database table to search: TableName Field001 Field002 Field003 Example SQL to search fields with some or all of the fields matching: SELECT * FROM
TableName WHERE Field001 LIKE 'string' OR Field002 LIKE 'string' OR Field003;
For future reference the PHP website as well as the MySQL website have examples for any type of functionality you wish to locate. I would suggest researching a the 'select' command from the MySQL website: http://dev.mysql.com/doc/refman/5.0/en/select.html
---- Jas "Tomorrow isn't promised so we live for today"+ _Emiliano Boragina // Diseño y Comunicación /////////////+ _emiliano.boragina@gmail.com //// 15 40 58 60 02 //////////////////////////+ _