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 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 looking for:
> >
> > table1
> > ----------------------
> > id name
> > 1 peter
> > 2 john
> > 3 mary
> > 4 lisa
> > 5 me
> >
> > I need a select that always retrieves id 1 and an interval
> > of my choice:
--
Mike Aubury
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
