Here one way you can do it (untested):
Justin
on 23/06/03 10:41 AM, Artoo ([EMAIL PROTECTED]) wrote:
> Hi,
>
> How can I start searching for the first space in a string while starting at
> say the 150th character? I'm trying to display the first 150 characters of
> an article that is store
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 sele
Hi,
How can I start searching for the first space in a string while starting at
say the 150th character? I'm trying to display the first 150 characters of
an article that is stored in a LONGTEXT filed of a MYSQL database, and
should the 150th character be inside a word, I would want to finish
dis
3 matches
Mail list logo
