mysql中如何统计某字段里某个字符的个数

select * from order where length(order_num)-length(replace(order_num,'8','')) = 4