Or rather SUBSTRING_INDEX(str,delim,count) Because you want to use a custom delimiter (space, comma)
Ignatius ____________________________________________ ----- Original Message ----- From: "Peter Lovatt" <[EMAIL PROTECTED]> To: "Bruce Levick" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 11:40 PM Subject: RE: [PHP-DB] first 10 or so words > try SUBSTRING > > http://www.mysql.com/doc/en/String_functions.html > > Peter > > -----Original Message----- > From: Bruce Levick [mailto:[EMAIL PROTECTED]] > Sent: 13 February 2003 22:23 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] first 10 or so words > > > Howdy, > I have a SELECT query displaying the results in repeated rows in a > table. I have a COMMENTS column coming out of the database table which > will likely contain a paragraph of information. I would like to display > only the first 10 or so words and then have a more link that people can > click on to display all the info. Is there a simple method for this?? > > Cheers > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
