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

回答編集履歴

1

SQL修正

2017/05/26 04:32

投稿

m.ts10806
m.ts10806

スコア80888

answer CHANGED
@@ -26,8 +26,8 @@
26
26
  select
27
27
  * -- 省略します
28
28
  from tbl_message_pre
29
- where (from_user = '山田' or from_user = '山田')
29
+ where (from_user = '山田' or to_user = '山田')
30
- and (from_user = '田中' or from_user = '田中')
30
+ and (from_user = '田中' or to_user = '田中')
31
31
  order by created_at desc
32
32
 
33
33
  ```