Using replace and concat in MySQL 8 version

Question

I have strings values such as the following in a column:

<span style=text-align: justify;>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</span>

I want to perform a balanced string replacement as follows:

<p style=margin-top: 0;>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</p>

I have tried to do this with the REPLACE and CONCAT functions but didn't get the desired output.

For example:

mysql> SELECT REPLACE (
        contents,
        CONCAT( "<span style=text-align: justify;>", contents, "</span>" ),
CONCAT( "<p style=margin-top: 0;>", contents, "</p>" )) q 
FROM
    t_contents 
WHERE
    contents LIKE '%<span style=text-align: justify;>%';

+--------------------------------------------------------------------------------------------------------------------+
| q                                                                                                                  |
+--------------------------------------------------------------------------------------------------------------------+
| <span style=text-align: justify;>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</span> |
+--------------------------------------------------------------------------------------------------------------------+
1 row in set (0.14 sec)

How can I achieve this result in MySQL 8 version?

Bernd Buffen · Accepted Answer · 2021-04-07 11:11:24Z

1

try something like this:

SELECT REPLACE( REPLACE(
'<span style=text-align: justify;>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</span>','<span style=text-align: justify;>','<p style=margin-top: 0;>'),
'</span>','</p>')
;

answered Apr 7, 2021 at 11:11

Bernd Buffen

15.1k2 gold badges27 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using replace and concat in MySQL 8 version

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related