mysql find word ending with code example

Example: mysql value ends with

WHERE value LIKE '%substring'