SELECT * FROM `myTable` WHERE `mov_id` LIKE '%1' OR `mov_id` LIKE '%2'

SELECT * FROM mytable
WHERE (mov_id MOD 10) IN (1, 2)

SELECT * FROM mytable
WHERE SUBSTRING(mov_id, -1) IN ('1', '2')

mov_id

Select feild1 from table where right(feild1,1) = x