I have a problem with concatenation in regular expressions:

Why does 'AB12345A1' RLIKE  '^AB.[0-9]{1,7}.[A-Z]{1}.[0-9]{1}\$' return FALSE but

'AB12345A' RLIKE  '^AB.[0-9]{1,7}.[A-Z]{1}\$' returns TRUE?

Thanks,

Markus