使用内部联接在mysql更新中连接字段名称

Question

Concatenating two field names from different tables using INNER JOIN during UPDATE statement.

I am trying to concatenate two field names in a mysql update statement.

This is what I have so far, needless to say it isn't working, any suggestions would be much appreciated.

    UPDATE products 
INNER JOIN sub_categories ON sub_categories.id = products.sub_category 
SET
    slug = replace(trim(lower(sub_categories.subcat_name).(products.product_name)), ' ', '-');

Answer 1

You can try as per below-

UPDATE products pr INNER JOIN sub_categories sc ON sc.id = pr.sub_category 
SET slug = REPLACE(TRIM(LOWER(CONCAT(sc.subcat_name,'.',products.product_name))),' ', '-');