• notice
  • Congratulations on the launch of the Sought Tech site

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

Tags

Technical otaku

Sought technology together

Related Topic

1 Comments

author

lipitor 40mg price & lt;a href="https://lipiws.top/"& gt;buy generic atorvastatin 80mg& lt;/a& gt; lipitor 40mg tablet

Japutm

2024-03-07

Leave a Reply

+