select *
from your_table
where (
your_column like '%11111$'
or your_column like '%22222%'
or your_column like '%33333%'
or your_column like '%44444%'
or your_column like '%55555%'
or your_column like '%66666%'
or your_column like '%77777%'
or your_column like '%88888%'
or your_column like '%99999%'
or your_column like '%00000%'
or your_column like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9] ('
The
likeoperator can help you there:select * from yourtable where yourcloumn like '%[0-9][0-9][0-9][0-9][0-9]%'select * from yourtable where yourcloumn like '%([^0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9] (%'请记住：[0-9]表示一个数字字符，[^ 0-9]表示任何非数字字符