mysql like查询 - 根据多个条件的模糊匹配查询

select t.`frame_no` as '卡券编号' ,t.policy_date as '起保日期',t.`create_date` as '发券时间'  from `券码表` t 
WHERE frame_no like 'DE2377F3C27B4E80AABB1A7E46CCA4A5%'
or frame_no like '52A2F0F4FF671266E05490E2BAAF1E48%'
or frame_no like '52A2F16015491266E05490E2BAAF1E48%'

posted on 2024-08-09 07:24 oktokeep 阅读(18) 评论(0) 编辑收藏举报