How to replace using sql?

H

H

Horosh2942020-08-12 16:33:49

SQL

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

How to replace using sql?

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

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 ...

Similar questions

D

Danil2017-08-17 10:54:09

Why is there no network printer connection? 2Reply

S

SteepNET2020-02-17 20:18:37

Print values from $_POST and $_COOKIE? 2Reply

I

Ivan Medvedev2020-03-04 08:06:16

How to make several page layout options depending on the value of a variable? 2Reply

K

Kamil2020-03-19 10:33:29

How to extract information from habr? 3Reply

S

sylens2020-03-31 10:26:30

Yandex Maps API. How to track the appearance of objects on the map? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question