How to create such a query to the database in sql?

Question

SQL

In general, you need to execute the following query:

UPDATE dle_post SET xfields = '||iframe2|https://site.ru/h3JunK4x17sJ?title=1?kp_id=(`kp_id_movie`)'

Instead of (`kp_id_movie`), you need to insert data from this (`kp_id_movie`). How can this be implemented?

Answer 1

If I understood correctly

DECLARE @kp_id integer
    SET @kp_id = (SELECT kp_id_movie FROM dle_post)
UPDATE dle_post
    SET xfields = CONCAT('||iframe2|https://site.ru/h3JunK4x17sJ?title=1?kp_id=', @kp_id)

Answer 2

Just do it, through the concatenation of strings.
Just be aware that this approach is vulnerable to injections.