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
I searched everything I could think of. Where should I have
found this is the manual?
Nowhere in the PHP manual, I think. But you could find
info on this in the MySQL manual (or any other db server's
documentation...)
Chris
, 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
://developer.ecorp.net/sqltut.htm
--Matt
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
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
: RE: [PHP-DB] WHERE field = str
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