Posted by laredotornado on 11/23/05 18:22

Hello,

Using MySQL 4, how do I write a SELECT statement that returns the
portion of the string after the last comma in the string? That is, if
I have a field with a value

"a,b,c,d,e"

and

"a,b,c,eee"

I would like to write an SQL statement that returns "e" in the first
case and "eee" in the second case.

Thanks for your help, - Dave

• Next in forum: Re: Referer site is https or not
• Prev in forum: Re: Where Not Exists
• Thread view: Extracting part of a string

[Reply to this message]