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) from 'description'.
This is what I came up with: "SELECT ID, name, LEFT(description,95), IF(enrolling = 1,'Currently enrolling','') FROM trials 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. larry. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
