subject:"Re\: \[PHP\] regexp with mysql"

Re: [PHP] regexp with mysql

2004-01-15 Thread CPT John W. Holmes

ECTED]>; "PHP" <[EMAIL PROTECTED]> Sent: Thursday, January 15, 2004 10:48 AM Subject: Re: [PHP] regexp with mysql > i guess > > SELECT * FROM `table` WHERE ids REGEXP ',2,|^2,|,2$' > > should do it... > > hth > > toby > > >

Re: [PHP] regexp with mysql

2004-01-15 Thread Toby Irmer

i guess SELECT * FROM `table` WHERE ids REGEXP ',2,|^2,|,2$' should do it... hth toby - Original Message - From: "Lowell Allen" <[EMAIL PROTECTED]> To: "PHP" <[EMAIL PROTECTED]> Sent: Thursday, January 15, 2004 4:39 PM Subject: Re: [PHP]

Re: [PHP] regexp with mysql

2004-01-15 Thread Lowell Allen

> i hope someone can help it should be easy but i still don't get it. > > i have a field which has numbers seperated via a comma > for example 1,2,3,12,14,23,51 > > now if i was to do a search for a the rows that has '2' in it i do > SELECT * FROM table WHERE ids REGEXP "2" > > will it show fiel