Re: limit on displaying a LONGTEXT filed from MySQL database
| From: | Adam i Agnieszka Gasiorowski FNORD | Date: | Mon, 23 Jun 2003 01:06:54 +0000 |
| Subject: | Re: limit on displaying a LONGTEXT filed from MySQL database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-152463@lists.php.net to get a copy of this message | ||
Artoo wrote:
> For example supose the 150th character is the v in the word "privileges" I
> would want to finish displaying the word and end with "privileges" rather
> then ending with"priv"
How about using the SUBSTRING_INDEX function
with delimiter set to ' ' (space). You could select
for example - 25 words - with it, I think.
--
Seks, seksić, seksolatki... news:pl.soc.seks.moderowana
http://hyperreal.info / ALinkA / bOrk! * WiNoNa ) (
http://szatanowskie-ladacznice.0-700.pl
foReVeR( * )
Poznaj jej zwiewne kształty... http://www.opera.com 007