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] -- 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]
