How to decode htmlencoded result in mysql command

Question

SQL query

Output

What I need to be as output

Need out put as below:

"l22s '" => "l22s ."

If there are any HTML encoded strings , I need to decode them in select.

is this useful for you? https://stackoverflow.com/questions/3678980/is-there-a-mysql-function-to-decode-html-entities — sddk, May 31 '21 at 12:42

sddk · Answer 1 · 2021-06-03T12:07:59.773

0

Try this, you need to extend WHEN POSITION(... IN locations.name) THEN REPLACE(locations.name, ..., ...) statements as much as you need.

SELECT REPLACE(locations.name, '&apos;', '.')
FROM `locations`
SELECT 
CASE
  WHEN POSITION("&apos;" IN locations.name) THEN REPLACE(locations.name, '&apos;', '.')
  WHEN POSITION(<yourSecondItem> IN locations.name) THEN REPLACE(locations.name, <yourSecondItem>, <yourSecondReplaceItem>)
END AS `Name`
FROM `locations`
WHERE <yourWhereCriteria>

edited Jun 03 '21 at 12:07

answered May 31 '21 at 09:19

sddk

1,115
1
10
20

If there are any HTML encoded strings , I need to decode them in select. – kalanamw May 31 '21 at 11:57
@kalanamw, have a look at updated answer. – sddk Jun 03 '21 at 12:06

How to decode htmlencoded result in mysql command

1 Answers1