SQL Statement to Update User Database

[matthewamzn]

I want to update all the users in my database to have email notifications enabled. I can't figure out what the exact sql query should be. This is what I have so far:

UPDATE "eshop_users"
SET "emailnotify" = yes
WHERE emailnotify = "no"

[coopster]

If you want to UDPATE all records, don't even use a WHERE clause:

UPDATE eshop_users SET emailnotify = 'yes';