Insert value from field1 to field2 with additional info

Applications Programming
1

Need help - hopefully I explain it correctly

I have a table in mysql database with multiple fields.
2 of the fields are called id and id_link

id    id_link
93    http://test_server/testpage.cgi?93
95    
96    
97    
98

I need to find the correct sql to update all of the id_link fields to contain the link http://test_server/testpage.cgi? with the id matching that row at end of id_link

So as per id 93 - I would update the id_link field to have http://test_server/testpage.cgi? plus the value of id (93) at the end and come up with http://test_server/testpage.cgi?93

Can you help please?

2 
update <table_name> set id_link = concat('http://test_server/testpage.cgi?',id);
1 Like
3

Perfect - Thanks for the help !