I would like to update an IP from a table called account_details from 64.246.50.XX to 67.15.159.XX but only when the domain column from client_package start with the letter "a".
I tried the following query:
update account_details a set a.ip='67.15.159.XX' where a.ip='64.246.50.XX' and a.client_id in (select p.client_id from client_package p where p.domain like 'a%')
But got an error:
#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 'select p.client_id from client_package p where p.domain like 'a
Thank you very much
█ Dedicated Servers, Managed OpenStack Cloud, Colocation and Managed Colocation in Brazil
█ Privately owned 10,000 server capacity Data Center