MojoSwift Posted February 17, 2020 Share Posted February 17, 2020 Hi all, Really hoping someone can help me out with this one. I've been banging my head on the walls. 🥺 As mentioned in the title, I'm trying to update the 'alias' field in the ps_address table in my database. Currently it simply says "My address" but I need it to be in Japanese and read "自分の住所". I've tried to run this SQL command : Quote UPDATE ps_address SET alias = 自分の住所 WHERE alias = My address However it just tells me Quote #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 'address' at line 3 I'm not very familiar with SQL. Can anyone tell me how to fix this? Thanks in advance Link to comment Share on other sites More sharing options...
ventura Posted February 17, 2020 Share Posted February 17, 2020 Try it adding quotes in alias field UPDATE ps_address SET alias = '自分の住所' WHERE alias = 'My address' It´s a text field 1 Link to comment Share on other sites More sharing options...
MojoSwift Posted February 18, 2020 Author Share Posted February 18, 2020 18 hours ago, ventura said: Try it adding quotes in alias field UPDATE ps_address SET alias = '自分の住所' WHERE alias = 'My address' It´s a text field Quotes for a text field!! 😝 Gotcha. That did the trick. Thank you Ventura. Much appreciated. 🙏 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now