Let's just say I have a table called TABLE_NAME
that looks like this:
id | name | changeme
------------------------
1 | One | 1
2 | Two | 0
3 | Three | 1
4 | Four | 0
5 | Five | 0
Is there an SQL statement I can run on this to change every changeme
entry to '0'?
do you mean?
UPDATE TABLE_NAME SET changeme = 0
update TABLE_NAME set changeme = 0 where changeme = 1
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With