RE: [PHP-DB] WHERE field = str
| From: | Paul DuBois | Date: | Wed, 25 Jul 2001 21:08:03 +0000 |
| Subject: | RE: [PHP-DB] WHERE field = str | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-10772@lists.php.net to get a copy of this message | ||
At 2:55 PM -0400 7/25/01, Matthew Loff wrote:
Certainly not in the PHP manual, and LIKE isn't really covered in the MySQL manual either...Of course it is. http://www.mysql.com/doc/S/t/String_comparison_functions.html
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-- Paul DuBois, paul@snake.net