# 查询已知架构下含有的相应部门名称
SELECT
id,
department_name,
concat( "%", department_name, '%' ) as like_string
FROM
department
WHERE
department_name != ""
AND department_name IS NOT NULL
AND "null/A公司/A1部门/A11部门" LIKE concat( "%", department_name, '%' );
mysql 反like查询
最新推荐文章于 2024-04-15 15:19:52 发布