teratail header banner
teratail header banner
質問するログイン新規登録

質問編集履歴

2

文法の修正

2015/04/30 01:13

投稿

miconear
miconear

スコア31

title CHANGED
File without changes
body CHANGED
@@ -42,7 +42,8 @@
42
42
  SELECT rank, product
43
43
  FROM ranking
44
44
  WHERE
45
- area = 13
45
+ pref = 13
46
+ area = 2
46
47
  AND NOT (rank IS NULL)
47
48
  ORDER BY rank ASC
48
49
  LIMIT 0, 10

1

文法修正

2015/04/30 01:13

投稿

miconear
miconear

スコア31

title CHANGED
File without changes
body CHANGED
@@ -60,7 +60,7 @@
60
60
  FROM ranking
61
61
  WHERE
62
62
  pref = ?
63
- area = ?
63
+ AND area = ?
64
64
  AND NOT (rank IS NULL)
65
65
  ORDER BY rank ASC
66
66
  LIMIT 0, 10");