Or rather SUBSTRING_INDEX(str,delim,count) Because you want to use a custom delimiter (space, comma) Ignatius ____________________________________________ ----- Original Message ----- From: "Peter Lovatt" <pjln1@sunmaia.net> To: "Bruce Levick" <brucel@ispye.com>; <php-db@lists.php.net> Sent: Thursday, February 13, 2003 11:40 PM Subject: RE: first 10 or so words > try SUBSTRING > > http://www.mysql.com/doc/en/String_functions.html > > Peter > > -----Original Message----- > From: Bruce Levick [mailto:brucel@ispye.com] > Sent: 13 February 2003 22:23 > To: php-db@lists.php.net > Subject: 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
