COMPLICATED UPDATE

how do I make a query that does this? update tbl_a set location_code=0 where tbl_a.country_id = (select id from countries where has_zones=0) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: weird kind of join

This is the first one I tried, it works great, thanks - Original Message - From: "Gordon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "'Diana Castillo'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, September 29, 20

weird kind of join

JOIN table_b ON (table_a_code = left(table_b.code,2)) because I will only match the ones that have 2 character codes. Diana Castillo Global Reservas, S.L. C/Granvia 22 dcdo 4-dcha 28013 Madrid-Spain Tel : 00-34-913604039 Ext 216 Fax : 00-34-915228673 email: [EMAIL PROTECTED] Web :

query with escape characters

apping.provider_code = 25) and (intl_province_mapping.provider_city_code = 'S\'ARENAL')) Diana Castillo Global Reservas, S.L. C/Granvia 22 dcdo 4-dcha 28013 Madrid-Spain Tel : 00-34-913604039 Fax : 00-34-915228673 email: [EMAIL PROTECTED] Web : http://www.hotelkey.com http://www.destinia.com