1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

to select range of id from table

Discussion in 'MySQL' started by kalaid, Jul 21, 2007.

  1. kalaid

    kalaid New Member

    Joined:
    Jul 21, 2007
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    0
    Hi,
    how do you choose a range of ID from a db?

    I used query to select record matched with particular id
    $data = mysql_query("SELECT * FROM table_name WHERE (id=2)")

    I tried like above query to select record with id's 2 through 9
    $data = mysql_query("SELECT * FROM table_name WHERE (1<id<9)")

    it didnt work. Help me
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,285
    Likes Received:
    364
    Trophy Points:
    83
    Use the between keyword.
     

Share This Page