String interpolation

[Mharugha Thugha]

Hello,

I'm trying to do an update, and I need to interpolate a (Subquery) inside a string.

Bellow you can see my example:


set @NT1 := 'select name from product where id=1 limit 1';

Update Conf
Set Data = '{\"ItemGroupId\":3,\"ItemDisplaySettings\":\"Text\":\"Example\",\"Text\":\"product'&@NT1&' is ok\",\"ImagePosition\":2}', stampsync='2021-10-14 22:07:17.168127'


Thank you in advance for your cooperation