SQL command to add to end of string

Question

I'd like a bit of help please with an SQL command

I have some text and I need to add and an extension to the end of the string on anything.

I've tried this but it doesn't work the way I want it to:

UPDATE table1 SET column1  = '%TEST%' WHERE 'column1' LIKE '%TEST%' + '.exe'

as the output I'd like is

TEST1.exe
TEST2.exe
TEST3.exe

Possible duplicate of How can I append a string to an existing field in MySQL? — ambianBeing
– ambianBeing, Commented Sep 27, 2019 at 21:43

Nick · Accepted Answer · 2019-09-27 21:40:51Z

2

You need to use CONCAT to add to the string, and your UPDATE syntax isn't quite right. This should work:

UPDATE table1
SET column1 = CONCAT(column1, '.exe')
WHERE column1 LIKE '%TEST%'

answered Sep 27, 2019 at 21:40

Nick

147k23 gold badges67 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

looking into the mysql databse its added it outside the [ ] is there anyway to get it inside the [ ] ["TEST1"].exe

@DanielPeters can you show me some sample data - the data in your question doesn't have any [] around it...

["http:\/\/URL1\/1"]

@DanielPeters I presume you want to end up with ["http://URL1/1.exe"]? What version of MySQL are you running?

msql 5.7.26 the url displays like that in phpmyadmin i think it would need to end up as ["http:\/\/URL1\/1.exe"]

|