Page 1 of 1

First 10 words of database entry how?

Posted: Sat Dec 08, 2007 3:21 pm
by cturner
I am wondering if someone, could please tell me how I can display only the first 10 words of a database entry? Thanks in advance.

Posted: Sat Dec 08, 2007 7:26 pm
by John Cartwright
Hmm, I can't think of anyway to grab the first 10 words. You can use LEFT() to get the X amount of characters, or you can use php to perform the regex to capture the 10 words.

viewtopic.php?t=25351

Posted: Sun Dec 09, 2007 11:20 am
by feyd
SUBSTRING_INDEX()?