Re: [PHP] mysql Pattern Matching

2003-09-05 Thread Curt Zirzow
* Thus wrote CPT John W. Holmes ([EMAIL PROTECTED]): > From: "Ralph Guzman" <[EMAIL PROTECTED]> > > > > Is there an advantage or difference in running FIND_IN_SET() instead of > > LIKE? > > Actually no, I guess there isn't. Neither one will use an index. There will be a slight diffence in the r

Re: [PHP] mysql Pattern Matching

2003-09-05 Thread CPT John W. Holmes
From: "Ralph Guzman" <[EMAIL PROTECTED]> > Is there an advantage or difference in running FIND_IN_SET() instead of > LIKE? Actually no, I guess there isn't. Neither one will use an index. mysql> desc test; +---+-+--+-+-+---+ | Field | Type| Null | Key

RE: [PHP] mysql Pattern Matching

2003-09-05 Thread Ralph Guzman
Is there an advantage or difference in running FIND_IN_SET() instead of LIKE? -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 5:53 AM To: Ralph Guzman; PHP General Mailing List Subject: Re: [PHP] mysql Pattern Matching From

Re: [PHP] mysql Pattern Matching

2003-09-04 Thread Duncan Hill
> From: "Ralph Guzman" <[EMAIL PROTECTED]> > > >> I know this question is best for the mySQL mailing list, but I am unable >> to subscribe to their list at this moment so perhaps somebody here can >> help me out. >> >> I have a table with a field where amenities are listed together using a >> comma

Re: [PHP] mysql Pattern Matching

2003-09-04 Thread CPT John W. Holmes
From: "Ralph Guzman" <[EMAIL PROTECTED]> > I know this question is best for the mySQL mailing list, but I am unable > to subscribe to their list at this moment so perhaps somebody here can > help me out. > > I have a table with a field where amenities are listed together using a > comma delimiter

RE: [PHP] mysql Pattern Matching

2003-09-04 Thread electroteque
i'm doin this offlist -Original Message- From: Ralph Guzman [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:23 PM To: PHP General Mailing List Subject: [PHP] mysql Pattern Matching I know this question is best for the mySQL mailing list, but I am unable to subscribe to th