Trying to UPDATE alias field in ps_address table

[MojoSwift]

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

Expand  

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

Expand  

I'm not very familiar with SQL. Can anyone tell me how to fix this?

Thanks in advance

[ventura]

Try it adding quotes in alias field

UPDATE ps_address
SET alias = '自分の住所'
WHERE alias = 'My address'

It´s a text field

[MojoSwift]

  On 2/17/2020 at 12:32 PM, ventura said:

Try it adding quotes in alias field

UPDATE ps_address
SET alias = '自分の住所'
WHERE alias = 'My address'

It´s a text field

Expand  

Quotes for a text field!! 😝 Gotcha. 

That did the trick. Thank you Ventura. Much appreciated. 🙏