How to concatinate text on existing database entry?

Question

I have a table, whose fields are

id, name, link

the link holds the name of the page like "link" = "index.php". Now I want to update this field and add "page=" in front of "index.php". Using this method I would like to update every entry in my table.

My desired SQL syntax need to be something like this

UPDATE mytable set link= 'page=' + <existing value of link>;

Anyone know what to accomplish this?

Answer 1

UPDATE mytable Set link = "page:" || link

Answer 2

If you're using MySQL you can try:

UPDATE mytable SET link = CONCAT("page:", link)