RE: [PHP-DB] WHERE field = str
| From: | Matthew Loff | Date: | Wed, 25 Jul 2001 18:55:08 +0000 |
| Subject: | RE: [PHP-DB] WHERE field = str | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-10767@lists.php.net to get a copy of this message | ||
Certainly not in the PHP manual, and LIKE isn't really covered in the
MySQL manual either...
Here's a good page with an intro to SQL queries:
http://developer.ecorp.net/sqltut.htm
--Matt
-----Original Message-----
From: phpnet@SeaPort6.com [mailto:phpnet@SeaPort6.com]
Sent: Wednesday, July 25, 2001 2:46 PM
To: PHP DataBase-List
Subject: Re: [PHP-DB] WHERE field = str
Thanks Chris
I searched everything I could think of. Where should I have found this
is the manual? Dave
| > I am trying to find a str within a field using a select statement
| > like SELECT * FROM tablename WHERE fieldname has the string within
| > it Is there a way to do this?
|
| WHERE fieldname LIKE "%$string%"
|
| Chris
|
dave@SeaPortNet.com
SeaPortNetHosting: Reliable Web Hosting
Plans from $17.95 www.yourname.com
http://www.SeaPortNet.com/
1(209)551-7028
--
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