#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 1999
    Location
    Scotland
    Posts
    6
    Rep Power
    0
    Does anyone know how to retreive specific rows from a MySQL select...ie. I only want to retreive rows n-m from a large set.

    Cheers,
    James
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    Use LIMIT. LIMIT x returns x rows. LIMIT y,x returns x rows starting with row y.

Similar Threads

  1. Check if any rows returned.
    By PHPme in forum MySQL Help
    Replies: 2
    Last Post: January 15th, 2004, 05:58 PM
  2. Limiting number of rows returned for a join
    By marcuseby in forum MySQL Help
    Replies: 3
    Last Post: November 18th, 2003, 09:37 PM
  3. Setting a limit on rows returned
    By nickwinters in forum Database Management
    Replies: 2
    Last Post: July 24th, 2003, 09:22 PM
  4. rows returned by query are invisible
    By lectrixity in forum MySQL Help
    Replies: 2
    Last Post: October 7th, 2002, 05:08 PM
  5. Replies: 3
    Last Post: July 18th, 2001, 08:22 PM

IMN logo majestic logo threadwatch logo seochat tools logo