How to replace using sql?

H

Horosh2942020-08-12 16:33:49

SQL

Horosh294, 2020-08-12 16:33:49

the title of the pages does not contain color, but it should be, the title column is now "t-shirt" and should be "red t-shirt". How it is possible by means of sql commands to automate this process?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

Stalker_RED, 2020-08-12
@Horosh294

update myTable set title=CONCAT("красная ", title) where ...