pattern match

[Michel]

Where can I find infi or doc on "pattern match" used within WHERE clause
(mysql).
As I need to matche with PHP variables I'd prfer something adapted to PHP.
In "PHP&MySQL Web Devlpt" (Luke Welling) I can't see much....

[Pham Nuwen]

Michel wrote:

Where can I find infi or doc on "pattern match" used within WHERE clause
(mysql).
As I need to matche with PHP variables I'd prfer something adapted to PHP.
In "PHP&MySQL Web Devlpt" (Luke Welling) I can't see much....

I take it you want the DB to do the matching not PHP.

you want something like:

select cans_of from canned_goods where lower(cans_of) LIKE lower('%beans%');

this will get Beans, beans, Pork & Beans, Kidney Beans, etc.....

here is a good resorce for SQL:
http://www.w3schools.com/sql/default.asp

--
/---+----+----+----+----+----+----++----+----+----+----+----+----+---\
I ph***********@libertydice.org II No nation was ever ruined by I
I http://www.libertydice.org II trade, even seemingly the most I
I remove "3d6" to e-mail II disadvantageous. - Ben Franklin I
\---+----+----+----+----+----+----++----+----+----+----+----+----+---/

[Jan Pieter Kunst]

In article <bi**********@news-reader3.wanadoo.fr>,
"Michel" <Mi**************@wanadoo.fr> wrote:

Where can I find infi or doc on "pattern match" used within WHERE clause
(mysql).
As I need to matche with PHP variables I'd prfer something adapted to PHP.
In "PHP&MySQL Web Devlpt" (Luke Welling) I can't see much....

This describes MySQL's regular expression implementation:

<http://www.mysql.com/doc/en/Regexp.html>

JP

--
Sorry, <de*****@cauce.org> is een "spam trap".
E-mail adres is <jpk"at"akamail.com>, waarbij "at" = @.