RE: [PHP-DB] Query question about how to do a select which return s things that resemble the input
| From: | Boaz Yahav | Date: | Tue, 20 Jun 2000 12:54:23 +0000 |
| Subject: | RE: [PHP-DB] Query question about how to do a select which return s things that resemble the input | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-514@lists.php.net to get a copy of this message | ||
Use LIKE
SELECT * FROM MyTable WHERE MyField LIKE '%MyWord%'
Sincerely
berber
Visit http://www.weberdev.com Today!!!
To see where PHP might take you tomorrow.
-----Original Message-----
From: Maarten Stolte [mailto:M.Stolte@Samhoud.nl]
Sent: Tuesday, June 20, 2000 10:48 AM
To: 'php3@lists.php.net'; php-general@lists.php.net; php-db@lists.php.net
Subject: [PHP-DB] Query question about how to do a select which returns
things that resemble the input
Hi,
I'd like to know how to return some possibilities based on
a users input, e.g:
The users input is "terdam", and the db returns 'rotterdam,amsterdam,tordam'
How do i do this?
Maarten
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net