Topic awaiting preservation: a simple mysql query question... (Page 1 of 1) |
|
---|---|
Paranoid (IV) Inmate From: Lebanon |
posted 05-25-2003 22:03
Hello, |
Paranoid (IV) Inmate From: New Jersey, USA |
posted 05-25-2003 23:09
SELECT * FROM your_table WHERE id2 = 1 OR id2 = 3 |
Paranoid (IV) Inmate From: Lebanon |
posted 05-26-2003 05:39
No...not that what I am asking... |
Paranoid (IV) Mad Scientist with Finglongers From: Germany |
posted 05-26-2003 08:24
if I understood you correctly, you'll need to use 'group by' |
Paranoid (IV) Inmate From: Lebanon |
posted 05-26-2003 13:28
Hello, |
Paranoid (IV) Inmate From: Lebanon |
posted 05-26-2003 16:53
the suggest mssql solution is: quote:
|
Maniac (V) Mad Scientist with Finglongers From: Cell 53, East Wing |
posted 05-26-2003 18:33
lallous: The problem is that MySQL doesn't appear to allow subselects (despite what it says in my PHP book ). |
Paranoid (IV) Inmate From: New Jersey, USA |
posted 05-26-2003 20:08
Sorry I misunderstood the question the first time around lallous. |