Mysql query string replacement statement summary (database string substitute)
Replace the character 10005 in the field userid in the ubk_vhost_list table with 10010
UPDATE `table_name` SET `field_name`=replace (`field_name`,'from_str','to_str') WHERE `field_name` LIKE'% from_str%'
Description:
table_name ―― table name
field_name ―― field name
from_str ―― string to be replaced
to_str ―― string to be replaced
I ran a query today
UPDATE ubk_vhost_list SET userid=replace (userid,'10005','10010')
More detailed mysql string replacement statement can refer to the following article
UPDATE `table_name` SET `field_name`=replace (`field_name`,'from_str','to_str') WHERE `field_name` LIKE'% from_str%'
Description:
table_name ―― table name
field_name ―― field name
from_str ―― string to be replaced
to_str ―― string to be replaced
I ran a query today
UPDATE ubk_vhost_list SET userid=replace (userid,'10005','10010')
More detailed mysql string replacement statement can refer to the following article
lipitor 40mg price & lt;a href="https://lipiws.top/"& gt;buy generic atorvastatin 80mg& lt;/a& gt; lipitor 40mg tablet
Japutm
2024-03-07