Add value to database fields?

Question

MySQL

There is a url_alias table. It has two fields keyword and query. How to execute a query to add the value shop/ to the keyword field? those. what would eventually happen for example shop/znachenie-kotoroe-bilo-do-etogo
But this should be done only for those fields whose query contains product_id=
I.e. you need a query like this: if the query field contains product_id=, then add shop/ in the keyword at the beginning of the line,
please tell me

Answer 1

update url_alias set `keyword` = concat('shop/', `keyword`) where `query` LIKE '%product_id=%'