mysql if value ends with number code example

Example: mysql value ends with

WHERE value LIKE '%substring'