simple alternate query

[Miguel Vaz]

        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:

        select * from table1 where id >=3 and id<=5       WORKS and gets record 
3,4 and 5

        select * from table1 where id=1 and id >=3 and id <=4    DOESNT WORK

	i understand this last select shouldnt work for ilogical id's, but 
how can i get record 1,3,4 and 5?


        Thanks

        Miguel


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