Re: simple alternate query

[ViSolve DB Team]

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:

        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:


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]



--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.410 / Virus Database: 268.17.10/651 - Release Date: 1/24/2007




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]