Advanced Search on MySQL
| From: | Augusto Cesar Castoldi | Date: | Thu, 19 Apr 2001 18:54:38 +0000 |
| Subject: | Advanced Search on MySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-49396@lists.php.net to get a copy of this message | ||
How can I do a advanced "string" search in my MySQL tables?
Something like: I have a form with name, phone, age, e-mail... and I want
to fill some of those and search in the database where name has "name
typed in the form" and phone has "number typed in the form"....
How Can I do that by a MySQL command?
I don't know if it's somethin like: select * from users where name like
"%$name%"
regards,
Augusto Cesar Castoldi