Re: REGEXP is not optimized?

[Toa Sty]

Quote

PS. I see my post will look ugly. Better copy-paste it to notepad for easy reading. Are there any tags supported to make it look better?

Using [ code ] tags works :)

Regarding the REGEXP problem you're seeing, have a look at this and the reply I gave - it's pretty much the same issue just with REGEXP instead of abs.
http://forums.mysql.com/read.php?115,123254,123254#msg-123254

For your specific problem you might be able to get away with something like where name >='a' and name <='z' (or similarly: where name between 'a' and 'z') as that should use an index just fine.

Toasty

-----------------------------------------
email: 'toasty'*3 at gmail