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:

 

enum('v1','v2','v3',...)

 

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.

Never mind. The problem was I used the wrong Java function. I had the right regex but I needed to use Matcher not split. Sorry.