How to extract all values except the last value in a string separated by comma in sql

[asifakhtar]

I am think of SUBSTRING_INDEX but dont know how to extract all values except the last value in a string separated by comma

e.g :
value is "aaa,bbb,ccc,ddd"
desired result is "aaa,bbb,ccc"

e.g :
value is "a1,b2,c3,d4,e5"
desired result is "a1,b2,c3,d4"

 

[BigDady]

You have arrA and want arrB which is arrA without the last element:
arrB = arrA.pop();

 

[asifakhtar]

You have arrA and want arrB which is arrA without the last element:
arrB = arrA.pop();

Hey I was looking for this and I figured it out with the following code:
SELECT SUBSTRING('aaa,bbb,ccc,ddd', 1, LENGTH('aaa,bbb,ccc,ddd') - LOCATE(',', REVERSE('aaa,bbb,ccc,ddd'))) AS result;
SELECT SUBSTRING('a1,b2,c3,d4,e5', 1, LENGTH('a1,b2,c3,d4,e5') - LOCATE(',', REVERSE('a1,b2,c3,d4,e5'))) AS result;