求sql语句，查询int型字段中包含数字8的记录

Question

int字段名称：haoma，记录每位参与者的幸运号码。
一等奖包含3个数字8，sql写法
二等奖包含两个数字8，sql写法
三等奖包含一个数字8，sql写法
php新手求指点，谢谢

Answer 1

select haoma as 一等奖 from tablename where haoma like '%8%8%8%';

select haoma as 二等奖 from tablename where haoma like '%8%8%' and haoma not like '%8%8%8%';

select haoma as 三等奖 from tablename where haoma like '%8%' and haoma not like '%8%8%' and haoma not like '%8%8%8%';

Answer 2

一等奖select * from tb_name where haoma like '%8%' and haoma not like '%8%8%' ;
其他的类似