Hello all. I have a MySQL field called 'description' that contains a
paragraph of text. I want to pull out the first 30 words (or there about)
This is what I came up with:
IF(enrolling = 1,'Currently enrolling','')
ORDER BY name ASC
LIMIT $offset, $limit"
Obviously this grabs the first 95 characters from 'description', but when I
display 'description' the word at the end of the string (after the 95th
charter) is often cut right in the middle.
I know that I could select the whole field then use a regex to chop the
string at the first '.' but I would rather have a SQL statement that only
grabs the text I need.
So how do I write a SQL statement that will grab the first 30 words without
chopping the last word?
Thanks for your time.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php