how would I update multiple rows in mysql

[newprogram]

I want to be able to update let say anyone with the userid in the rang of 300 to 500 change thier column's which has the name "staic" from "paid" to "not paid".

[F1Fan]

UPDATE table SET staic = 'not paid' WHERE userid BETWEEN 300 AND 500

[newprogram]

thank you !!

UPDATE table SET staic = 'not paid' WHERE userid BETWEEN 300 AND 500

[newprogram]

can you please help with one more thing , wont to add a check to only change the ones with "static =  USA2"

I tried this and it not working.

UPDATE table SET static = USA1 WHERE static =  USA2 AND id BETWEEN 300 AND 500

 

thank you !!

 

[F1Fan]

Strings must have single quotes around them.

UPDATE table SET static = 'USA1' WHERE static = 'USA2' AND id BETWEEN 300 AND 500

[newprogram]

I getting this = 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 ''USA2' AND id BETWEEN 300 AND 500' at line 1

Strings must have single quotes around them.

UPDATE table SET static = 'USA1' WHERE static = 'USA2' AND id BETWEEN 300 AND 500

[newprogram]

my bad i got it forgot a "="

thank you

work great

I getting this = 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 ''USA2' AND id BETWEEN 300 AND 500' at line 1

Strings must have single quotes around them.

UPDATE table SET static = 'USA1' WHERE static = 'USA2' AND id BETWEEN 300 AND 500