I have large articles stored in my MySQL db and I want to only display 100 words from the top of each article in a 'list all articles page'.
How do I do this?
thanks for the help
Jason
Limit Text length/word count
Moderator: General Moderators
you might use SUBSTRING(str,pos,len) to limit the number of characters returned.
http://www.mysql.com/doc/en/String_func ... ml#IDX1183
http://www.mysql.com/doc/en/String_func ... ml#IDX1183