MySQL Forums
Forum List  »  Newbie

View with deconcatenated Field
Posted by: Ben Winkley
Date: February 19, 2014 09:21PM

I want to create a view with part of a field.
I want to get the last part of the value which is eveything after -ghg-, the problem is the the string length preceeding and following will change.
i want the full string following -ghg-


Field link:
XXX-ghg-XXXXX
XXXXX-ghg-XX
XXXX-ghg-XXXXXXXX

Options: ReplyQuote


Subject
Written By
Posted
View with deconcatenated Field
February 19, 2014 09:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.