[VladimirMark]

Ok, so I own a database which I want all "Owned" value to 0 from 1
Is any way to do it at once, or I need to do it one by one because I have to many houses :/

[ajam112]

Comment removed

*Ye xD*

[VladimirMark]

Don't post If you are not sure, bro

[Calgon]

Run this SQL query:

Код:

UPDATE Houses SET Owned = 1 WHERE Owned = 0

Change "Houses" to the table name you're using if that's not correct.

[VladimirMark]

Ok, thank you bro

[VladimirMark]

Another Question, If I want to edit the "OwnerName" to "Nobody" and it has different names how can I do it?

[Calgon]

Код:

UPDATE Houses SET OwnerName = "Nobody" WHERE OwnerName != "Nobody"

I believe a query like that should work.

[VladimirMark]

I really love you, bro
Thanks for everything