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

Similar questions

L

lutokris2021-03-25 14:12:22

Why does memory allocation for a string look out of pattern? 4Reply

L

last72015-12-06 18:40:18

Which database to choose to work with complex filters (WHERE conditions)? 3Reply

M

meta42012-08-31 14:32:31

What extensions of the relational model and articles on them do you know? 1Reply

T

TanderOFF2021-08-03 17:21:14

How to pass dictionary to sqlite database? 1Reply

S

sendnikkei2018-04-16 19:53:45

How to change values in one table by taking values from another? 2Reply

Didn't find what you were looking for?

Ask your question