'mysql update where if else cant get it prioritize

I want that, if there is a Premium account set one Premium account to inuse=1, if there is no premium account then update any else account.

But this does not prioritize Premium accounts, as it just updates the first entry in my db row. How to use this with if else / case. I couldnt find any if / else / case thread where its used in the WHERE part of the sql query

UPDATE accounts SET inuse = 1 WHERE accstatus = 'PREMIUM' AND inuse = 0 AND banned = 0
                                 OR inuse = 0 AND banned = 0 
LIMIT 1

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'mysql update where if else cant get it prioritize

Sources

Related Questions