When entering data, process string at the same time through php or mysql?

reason
suppose I want to input all the data of a number table, how can I change the value of this field to B if there is A? 

INSERT INTO `wp_posts` (`ID`, `content`)
VALUES
    (13335,"<h3></h3>\r\n[embed]https://www.instagram.com/p/Bcv_yv2lIIO/?utm_source=ig_embed[/embed]\r\n")

null

null
\ r\ n

< iframe src=
[/ embed] >

category is similar to this concept, what is the right thing to do?
or can I download string directly?

* *

becomes * *

whatever * * is, as long as it conforms to the rules?
is it faster than processing via php?
is to open a php file, and then delete the php file after writing it?

Mysql-optimized mysqli mysql php7 php
Jul.10,2021

you can use the preg_replace and str_replace methods to replace data before publication.

PHP: preg_replace-Manual- http://php.net/manual/zh/func.

the pseudo code is as follows 

$string_data = '';
$string_data = str_replace('\r\n','<br />',$string_data);
$string_data = str_replace('[embed]','<iframe src=',$string_data);
$string_data = str_replace('[/embed]','></iframe>',$string_data);
$string_data = preg_replace('!<\w+?>([\s\S]+?)</\w+?>!','\\1<br />',$string_data);
$string_data = preg_replace('!<[/]?\w+>!','',$string_data);

Previous: Vue menu permission problem

Next: Mac reported an error when installing homebrew.

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e39811-44537.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e39811-44537.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?