Hello Mikael, Just add LIMIT 10 (which is equivalent to LIMIT 0,10) to show the first 10 records,
and LIMIT 10,10 to show 10 records starting from 10. This issue is covered in online docs. Regards, Tom Friday, April 19, 2002, 9:18:53 AM, you wrote: MH> This brings up another question to my mind. MH> What if I only want to show the first 10 records and then the next 10 MH> from that query? How do I do that? MH> This works on MsSQL: MH> "SELECT lyric_title FROM lyrics WHERE LEFT(lyric_title,1)='A'" >> I want to select all the records, which have the first letter matched >> the letter 'A'. >> >> $SQL_get_lyrics = "SELECT lyric_title FROM lyrics WHERE lyric_title >> LIKE \'A%\'"; >> >> Some how this statement given me other record, which has the letter A >> inside, too like: "Know A Word" and other other unexpected records --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php