LIKE语句通配符:%|_|[]
select * from cif_user cu where cu.name like '%cai%' ---名字中存在caiselect * from cif_user cu where cu.name like '%cai' ---名字以cai结尾select * from cif_user cu where cu.name like 'cai%' ---名字以cai开头...