SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE cities ( id int auto_increment primary key, city varchar(128) ); INSERT INTO cities(city) VALUES ('Брянск'),('Тула'),('Москва'),('Питер'),('Воронеж'); SELECT * FROM cities ORDER BY (city = 'Москва' OR city = 'Питер') DESC, city ASC;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear