Using pattern REGEXP for detecting number in the end of the string

The sample code:

SELECT * FROM table WHERE column REGEXP '[0-9]$'