What do I need to do?

[elentz]

I have the following query:

Update vtcrm.vtiger_products v , vtcrm.zipcodes z SET v.product_description = "Trip Charge -- z.city" Where v.productname = z.zipcode

I want the field product_description to be "Trip Charge -- (Then whatever city is in the z.city field) How can I do this.


Thanks Alot

 

[r937]

update vtcrm.vtiger_products v 
     , vtcrm.zipcodes z 
   set v.product_description 
     = concat('Trip Charge -- ', z.city)  
 where v.productname = z.zipcode

r937.com | rudy.ca

 

[elentz]

That worked perfectly,

Thank you