Re: mySQL Query and blank fields
| From: | Arpad Tamas | Date: | Thu, 25 Oct 2001 14:20:57 +0000 |
| Subject: | Re: mySQL Query and blank fields | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13713@lists.php.net to get a copy of this message | ||
On Thursday 25 October 2001 15:08, Rick Emery wrote:
> First, I wouldn't use length(), I'd use REGEXP: SELECT * FROM
> foo_table WHERE fieldname REGEXP '..+'
> It's quicker.
regular expression is faster then a length() call? that's seems
strange considering how complex a regexp can be
with regexp, it takes 0.13sec on a simple table with lenght it is
0.08sec.
Arpi