skip to Main Content

Can MySQL v5 extract multiple occurrences from strings?

Folks! I need some ideas, with the follow problem: I have a table in MySQL v5 that stores a string in a field, like the following: {"content":{"serviceResponse":{"state":{"code":"04","gloss":"CONTINUE"},"products":[{"product":{"productCode":"1" ,"subProductCode":"1"},"productAmount":{"amountGranted":1100000},"groupRisk":{"riskGroup":"A2"},"additionalinformation":{"franchiseTC":"3"," percentAdvance":"70.0"}},{"product":{"productCode":"2"},"groupRisk":{}},{"product":{"productCode":"7"}}]," client":{"newClient":"false","riskGroup":{"riskGroupCode":"A2"}}}} I need a MySQL v5 (version is important) SQL query…

VIEW QUESTION

Upper before Concat in Postgresql

Assuming there is a table called cities with columns name and country, why doesn't this query work? select concat(upper(name, ', ', country)) as location FROM cities; But the one below does? select upper(concat(name, ', ', country)) as location FROM cities;…

VIEW QUESTION
Back To Top
Search