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: Ralph
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 |
* 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 resuls
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
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 like:
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 like:
6 matches
Mail list logo