MySQL Forums
Forum List  »  Newbie

retrn a value from a string
Posted by: Steve Wilson
Date: February 08, 2019 05:31PM

Hi There,
Can you help please.
I have a table with fields that are key | value pairs.
I need to search the value field for a value and return a value between 2 characters.
So this is an example value "a:1:{s:15:"introducer_code";s:4:"6969";}"
I need to search for "introducer_code" and when found return the value "6969". This value can be any number so it might be a "1" or "16784" or anything so I need to be able to return the value between :" ";}" from the value shown above.
So I'm thinking it will be something using instring(len(Value)) or something like that.

Thanks for the help.

Best Regards,
Steve.

Options: ReplyQuote


Subject
Written By
Posted
retrn a value from a string
February 08, 2019 05:31PM
February 09, 2019 06:54AM
February 10, 2019 01:40PM


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.