SELECT SUBSTRING(COL3,0,100) AS COL3 FROM TABLE That will return the first 100 characters of your 10 pages of text... If you want characters 200 through 299 do: SELECT SUBSTRING(COL3,200,100) AS COL3 FROM TABLE Untested, but I am 99.9% sure that will meet your needs. Brian > > hmm...I don`t need the stuff from different rows. I have 10pages of text > in one in one rows one column, eg > col1 col2 col3 here is 10pages > > S. > > > > SELECT * FROM x LIMIT 1,10; > > > > Where 1 = Start record, > > 10 = How many records... > > > > Nexts queries will be: > > > > SELECT * FROM x LIMIT 11,10; > > and > > SELECT * FROM x LIMIT 21,10; > > etc... > > > > > > - Diogo Zulli > > > > ----------------------[ www.sphynx.com.br ]--------------------------- > > "Why Live on The Edge When You Can BASE Jump Off It" > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- 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