mysql statement question

Discussion in 'Programming' started by izlik, Jan 30, 2011.

0
  1. #1
    Hey

    I was wondering what the correct mysql query select collumns 2500-3000 as results from my database ? i know how to select one entry but not X to X entrys.

    edit: it's ID row 2500-3000 from the table "house" i want as result.
     
    Last edited: Jan 30, 2011
    izlik, Jan 30, 2011 IP
  2. TimK

    TimK Peon

    Messages:
    51
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2 
    SELECT * FROM house WHERE ID BETWEEN 2500 AND 3000;
    Code (markup):
     
    TimK, Jan 30, 2011 IP