回答編集履歴
1
chousei
answer
CHANGED
@@ -1,7 +1,10 @@
|
|
1
1
|
条件をつけてorder by する
|
2
2
|
|
3
3
|
```SQL
|
4
|
+
create table users(
|
5
|
+
id int primary key auto_increment,
|
4
|
-
|
6
|
+
name varchar(10) collate utf8mb4_unicode_ci
|
7
|
+
);
|
5
8
|
insert into users(name) values
|
6
9
|
('abc1'),
|
7
10
|
('Abc2'),
|
@@ -15,6 +18,8 @@
|
|
15
18
|
|
16
19
|
- ソート
|
17
20
|
```SQL
|
21
|
+
select * from users
|
18
|
-
|
22
|
+
order by case when name regexp '^[a-z]' then 1 else 2 end desc,
|
23
|
+
name asc;
|
19
24
|
|
20
25
|
```
|