回答編集履歴
1
修正
test
CHANGED
@@ -8,7 +8,9 @@
|
|
8
8
|
|
9
9
|
SELECT * FROM user
|
10
10
|
|
11
|
-
WHERE name like concat('%', coalesce(@name, name), '%')
|
11
|
+
-- WHERE name like concat('%', coalesce(@name, name), '%')
|
12
|
+
|
13
|
+
WHERE case when @name is not null then name like concat('%', @name, '%') else True end
|
12
14
|
|
13
15
|
AND category = coalesce(@category,category)
|
14
16
|
|