Part-2 of "not regexp"

I hate when my dumbness shows on world-wide tv Please nullify my last query= Subject: "not regexp" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: "not regexp"

At 9:24 AM -0400 8/24/01, Network wrote: >Would someone explain what is going wrong here. >obviously I'm not understanding something. >If the next query searches for patterns at the beginning of the string in a >column >mysql> select count(*) from a where addy1 not regex

"not regexp"

Would someone explain what is going wrong here. obviously I'm not understanding something. If the next query searches for patterns at the beginning of the string in a column mysql> select count(*) from a where addy1 not regexp '^(apt)|^(rm)|^(room)|^(ste)|^(suite)|