回答編集履歴
1
Typoを修正しました
answer
CHANGED
|
@@ -1,9 +1,9 @@
|
|
|
1
1
|
これだとSQLのシンタックスエラーになります。
|
|
2
2
|
|
|
3
|
+
```SQL
|
|
4
|
+
SELECT COUNT(*) AS cnt FROM article LIKE ? ORDER BY created DESC
|
|
5
|
+
# ↓ 以下のように変更
|
|
6
|
+
SELECT COUNT(*) AS cnt FROM article WHERE tag LIKE ? ORDER BY created DESC
|
|
3
7
|
```
|
|
4
|
-
SELECT COUNT(*) AS cnt FROM article LIKE ? ORDER BY created DESC'
|
|
5
|
-
-- ↓ 以下のように変更
|
|
6
|
-
SELECT COUNT(*) AS cnt FROM article WHERE tag LIKE ? ORDER BY created DESC'
|
|
7
|
-
```
|
|
8
8
|
|
|
9
9
|
もう一つのSQL文も同様です。
|