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

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 ?

---

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

SELECT SUBSTRING(column,-3) FROM myTable

---

Here is my solution :

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