How to only SELECT part of column value by REGEXP with MySQL ?

Question

Hi,

I have a column with values like "A001", "B002" AND "003", "004". I would like have this result :

SELECT column from myTable

+--------+
| column |
+--------+
| 001    |
| 002    |
| 003    |
| 004    |
+--------+

Is this possible ?

Answer 1

If you're looking for the last 3 characters in your field,

SELECT SUBSTRING(column,-3) FROM myTable

Answer 2

Here is my solution :

SELECT TRIM(LEADING 'A' FROM (LEADING 'B' FROM `column`)) FROM my_table