CODEWITHSUNDEEP
mysql
user3440798
user3440798

Reputation: 19

Mysql:Extract substring from string

How to extract substring from a string like

utm_term=beat%20complaint

Expected Result: beat complaint

utm_term=customer%20care

Expected Result: customer care

Upvotes: 0

Views: 94

Answers (1)

JCalcines
JCalcines

Reputation: 1286

You should check the documentation.

The function you are looking for is REPLACE

 SELECT REPLACE('utm_term', '%20', ' ');

Upvotes: 1

Related Questions