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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to