Mysql的通配符是 %
SELECT * FROM `ff_vod` WHERE `vod_pic` like ‘188%’ 查找”ff_vod”表,”vod_pic”字段以188开头的数据
SELECT * FROM `ff_vod` WHERE `vod_pic` like ‘%188’ 查找”ff_vod”表,”vod_pic”字段以188结尾的数据
SELECT * FROM `ff_vod` WHERE `vod_pic` like ‘%188%’ 查找”ff_vod”表,”vod_pic”字段包含188的数据
原创文章,作者:wwh,如若转载,请注明出处:https://www.wuwenhui.cn/3295.html