Hi,
I receive data in a MySQL D/b imported from a txt file and one of the fields is in the the following format:
CD101 - MS Kids - Creative Writer
What I need to do remove everything up to the first character after the first dash, my finished string should just be
MS Kids - Creative Writer
I'm at a loss as to how to do this. Any help or guidance is appreciated.