MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:August 19 1999 3:31pm
Subject:Reverse select statement
View as plain text  
Mick Hanna writes:
 > SELECT * FROM messages where username="bob" and to_user="fred";
 > 
 > i want the select statement to do the reverse at the same time and mix the rows
together
 > ordered by a timestamp......
 > ie:
 > one select for:
 > 
 > SELECT * FROM messages where username="bob" and to_user="fred" order by timestamp;
 > SELECT * FROM messages where username="fred" and to_user="bob" order by timestamp;
 > 
 > would a join statement work?
 > the manual is confusing me at the moment.....
 > 

Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped|
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+
Thread
Reverse select statementMick Hanna19 Aug
  • RE: Reverse select statementDon Read19 Aug
    • Re: Reverse select statementMick Hanna19 Aug
  • Reverse select statementsinisa19 Aug