I am trying to write a Java 'split' or 'matcher' regex to extract the individual values from a MySQL enum column. The format of the string to be parsed is:
There is an unknown number of values enclosed by apostrophes. Can someone help me with the regex to extract those values as my attempts have all been fruitless. I expect it is relatively simple for someone other than me. Note that there will be no apostrophes in the values. TIA.