如何让LIKE和COUNT返回小于不在行中的值的行数？

For example:

SELECT COUNT(ID) FROM My_Table
WHERE ID < 

(SELECT ID FROM My_Table
WHERE ID LIKE '%4'
ORDER BY ID LIMIT 1)    
SELECT COUNT(ID) FROM My_Table
W