sql模糊查询详解

--查出包含 has字符的 %'[include]'%
SELECT ddd.department_name, ddd.department_id FROM departments ddd WHERE ddd.department_name like '%has%'

--查出匹配位置的 从第一个字符串开始

SELECT ddd.department_name, ddd.department_id FROM departments ddd WHERE ddd.department_name like 'has%'


--查出匹配位置的 从第二个字符串开始

SELECT ddd.department_name, ddd.department_id FROM departments ddd WHERE ddd.department_name like '_has%'