Jump to content

Trying to UPDATE alias field in ps_address table


MojoSwift

Recommended Posts

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...