Hi,
You can use
select *
from table1
where id in (1,3,4,5);
Thanks,
ViSolve DB Team
- Original Message -
From: Miguel Vaz [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, January 28, 2007 7:51 AM
Subject: Re: simple alternate query
I am dumb, so sorry
Be careful there...
You should probably use '(' ')' around that ...
select * from table1 where id=1 or (id=3 and id=4)
On Sunday 28 January 2007 02:21, Miguel Vaz wrote:
I am dumb, so sorry:
select * from table1 where id=1 or id =3 and id =4
Have to go
06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Miguel Vaz [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 27, 2007 9:21 PM
To: mysql@lists.mysql.com
Subject: Re: simple alternate query
I am dumb, so sorry:
select * from table1 where id=1 or id
Hi,
I Cant get a simple query to work, heres what i am looking for:
table1
--
id name
1 peter
2 john
3 mary
4 lisa
5 me
I need a select that always
I am dumb, so sorry:
select * from table1 where id=1 or id =3 and id =4
Have to go spank myself until i bleed now, thanks.
Miguel
At 02:15 28-01-2007, Miguel Vaz wrote:
Hi,
I Cant get a simple query to work, heres what i am