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]