質問編集履歴
2
流れて欲しいSQLを修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -54,7 +54,7 @@
|
|
|
54
54
|
|
|
55
55
|
```ここに言語を入力
|
|
56
56
|
|
|
57
|
-
select * from user_favorite where fruit
|
|
57
|
+
select * from user_favorite where (fruit like '%1%' or fruit like '%3%' or fruit like '%5%') and (music like '%1%' or music like '%2%') and (game like '%3%' or game like '%4%');
|
|
58
58
|
|
|
59
59
|
```
|
|
60
60
|
|
1
流れて欲しいSQLを修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -54,7 +54,7 @@
|
|
|
54
54
|
|
|
55
55
|
```ここに言語を入力
|
|
56
56
|
|
|
57
|
-
select * from user_favorite where fruit like '%1%' or fruit like '%3%' or fruit like '%5%'
|
|
57
|
+
select * from user_favorite where fruit (like '%1%' or fruit like '%3%' or fruit like '%5%') and (music like '%1%' or music like '%2%') and (game like '%3%' or game like '%4%');
|
|
58
58
|
|
|
59
59
|
```
|
|
60
60
|
|