As the following statement indicated, it matches a string start with one or more digits following by a space. Could you explain to me why this end up with 0 instead of 1?
However, it outputs 1 if I simply removes ^. As I know, ^ matches the beginning of a string, didn't I use it incorrectly?
Thanks in advance.
SELECT "345 boxberry ave " REGEXP '^\d*[[.space.]][[:<:]]b';
 Basically, I want to match any street name start with 'b'.
The following recommendations will help you in your SQL tuning process.
You'll find 3 sections below:
SELECT '345 boxberry ave ' REGEXP '^\d*[[.space.]][[:<:]]b'