Placing a URL in the product descriptions

-- HikaShop version -- : 3.3.0
-- Joomla version -- : 3.8.6
-- PHP version -- : 5.6.34
-- Browser(s) name and version -- : opera 51.0.2830.55

Hi,
we have 2 licenced Hikashop sites and would like to include a standard clickable URL in the description field of one of the sites to the other. This so we only have to have one working checkout (we also have 2 separate physical shops).

We'd prefer to do this as a mass action and would like to know how to format the string (we know how to do text only).

Many thanks,
Ian and Stu

Hi,
I'll get someone to do this for use but would our new description with the link in it replace 'MyHTML' in your example?

Thanks,
Ian and Stu

Hi,
it comes back with a syntax error when I just try the word 'test' instead of 'MyHTML'.

Regards,
Ian and Stu

Hi,
it's;

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

I'll ask a friend who know a bit about sql to take a look.

Thanks,
Ian and Stu

Hi,
escaping the characters results in the same error. If I select 'update' from the phpadmin interface it gives me;

UPDATE `mus_hikashop_product` SET `product_description`=[value-4] WHERE 1

Can I adapt this?

Thanks,
Ian and Stu

Thanks Nicolas. That worked!

Kind regards,
Ian and Stu