Y
Y
Yuriy Berg2016-10-24 12:12:22
MySQL
Yuriy Berg, 2016-10-24 12:12:22

SQL inserting text into a column before native text, is it possible and how?

101d6c900b5d456483aa70c1d84598e9.png
Hello, is it possible to insert text into a column from a table, before native text.
Let's say /images/native text
Do it with SQL tools

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2016-10-24
@art_haacki

"native text" is what is already in the field before the query is executed?

update tablename set img_url = concat('/images/', img_url);

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question