SELECT '1'
WHERE '1' LIKE '%123%' --×
SELECT '2'
WHERE '%123%' LIKE '1' --×
SELECT '3'
WHERE '%1%' LIKE '123' --×
SELECT '4'
WHERE '123' LIKE '%1%' --√
以上测试在SQL Server 2016中,SELECT '4' WHERE '123' LIKE '%1%' 是正确的模糊查询
SELECT '1'
WHERE '1' LIKE '%123%' --×
SELECT '2'
WHERE '%123%' LIKE '1' --×
SELECT '3'
WHERE '%1%' LIKE '123' --×
SELECT '4'
WHERE '123' LIKE '%1%' --√
以上测试在SQL Server 2016中,SELECT '4' WHERE '123' LIKE '%1%' 是正确的模糊查询