firstly I apologise in advance if this has been asked 100 times over..
I've been ambushed by my company i "HAVE" to use an old Mysql 4.1 server something to do with an atiquated system still running that cannot be upgraded for x,y and z reasons. but they want a new report running..
If i have a comma delimited field with 5 values in can i return a specific value without the rest
ie
colA
Val1, Val2, Val3, Val4, Val5
Select
Substring_index(colA, ',' , -3) As Value 3
from table
can it just return val3 and not val3, val4, val5
I cannot use a substring length as the data value changes based on user input and is anywhere between 3 - 255 chars per value.
Many Many thanks in advance for your help....
Regards
KeeF