消息传递mysql表查询(Messaging mysql table query)

 我正在尝试实现一个消息传递系统，但略有不同。 消息只能从用户2启动到用户1.此启动消息具有start = 1值。 
 
+---------+----------+----------+-----------+----- -----+-------+---------------------+
| id (ai) | user1id  | user2id  | originated| to_user2  | start | messag              | 
+---------+----------+----------+-----------+-----------+-------+---------------------+
| 1       |  1       | 2        |  1234     |    0      |   1   | Hi                  | 
| 2       |  1       | 2        |  1234     |    1      |   0   | Hi back             | 
| 3       |  1       | 2        |  1234     |    0      |   0   | So Whats up         | 
| 4       |  1       | 2        |  1234     |    1      |   0   | Nothing much, why   | 
| 5       |  1       | 2        |  1234     |    0      |   0   | Just checking       | 
| 6       |  1       | 2        |  1234     |    1      |   0   | OK                  | 
+---------+----------+----------+-----------+-----------+-------+---------------------+
 
 所以我可以通过WHERE start ='1'来获取起始消息。 
 
 我能够从user1到user2获取做WHERE to_user2 ='1'的消息 
 
 通过执行WHERE to_user2 ='0'和start ='0'，我能够从user2到user1获取消息 
 
 对？ 跟着我？ 
 
 我将如何进行查询以便获得以下输出： 
 
STARTING MESSAGE  (id 1)
 message to user2  (id 2)          

              message to user 1  (id3)
              message to user 2  (id4)

                      message to user 1  (id5)
                      message to user 2  (id6)
 
 我希望我有所作为。 
 
 让我澄清一下，我能够使用6个不同的查询获得此输出，但我想知道这是否可行，以及它是否可能在1个查询中。 

I'm trying to implement a messaging system, but with a slight twist. Messages can only be started from user 2 to user 1. This starting message has the start = 1 value.
 
+---------+----------+----------+-----------+----- -----+-------+---------------------+
| id (ai) | user1id  | user2id  | originated| to_user2  | start | messag              | 
+---------+----------+----------+-----------+-----------+-------+---------------------+
| 1       |  1       | 2        |  1234     |    0      |   1   | Hi                  | 
| 2       |  1       | 2        |  1234     |    1      |   0   | Hi back             | 
| 3       |  1       | 2        |  1234     |    0      |   0   | So Whats up         | 
| 4       |  1       | 2        |  1234     |    1      |   0   | Nothing much, why   | 
| 5       |  1       | 2        |  1234     |    0      |   0   | Just checking       | 
| 6       |  1       | 2        |  1234     |    1      |   0   | OK                  | 
+---------+----------+----------+-----------+-----------+-------+---------------------+
 
So I'm able to get the starting message by doing WHERE start = '1'.
 
I'm able to get the messages from user1 to user2 doing WHERE to_user2 = '1'
 
I'm able to get the messages from user2 to user1 by doing WHERE to_user2 = '0' and start='0'
 
Right? following me? 
 
How would I make my query so that I get the following output:
 
STARTING MESSAGE  (id 1)
 message to user2  (id 2)          

              message to user 1  (id3)
              message to user 2  (id4)

                      message to user 1  (id5)
                      message to user 2  (id6)
 
I hope im making some sense.
 
Let me clarify that im able to get this output using 6 different querys, but i wonder if thats the way to go, and if its possible in 1 query.

原文：https://stackoverflow.com/questions/17132463