mysql - 如果我更新一行，所有其他行（包括更新的行）将返回更新的值

I've created a "activation" system for my website. There is a column called "active" in my DB, by default its value is the string "no" If i want to activate any user's account, I change active's value to "yes" Everything was working fine till i started to active a couple of accounts. After activating a single account (admin account), i echoed the value of the row active to see if everything was working fine, it printed "yes" But when i tried to login with unactivated accounts and echoed the value of the row active, they too returned "yes" But when i check in the DB, it says "no" When I don't activate any account (that is, if i dont change the active value of any account), all the accounts return "no" but when i try to activate one/more accounts all of them return "yes" I'm confused.I've created a "activation" system for my websi