> 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
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 fieldn
> 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
y, 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
to SQL queries:
>http://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
7;
Subject: 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