回答編集履歴
1
chousei
test
CHANGED
@@ -4,7 +4,13 @@
|
|
4
4
|
|
5
5
|
```SQL
|
6
6
|
|
7
|
+
create table users(
|
8
|
+
|
9
|
+
id int primary key auto_increment,
|
10
|
+
|
7
|
-
|
11
|
+
name varchar(10) collate utf8mb4_unicode_ci
|
12
|
+
|
13
|
+
);
|
8
14
|
|
9
15
|
insert into users(name) values
|
10
16
|
|
@@ -32,7 +38,11 @@
|
|
32
38
|
|
33
39
|
```SQL
|
34
40
|
|
41
|
+
select * from users
|
42
|
+
|
35
|
-
|
43
|
+
order by case when name regexp '^[a-z]' then 1 else 2 end desc,
|
44
|
+
|
45
|
+
name asc;
|
36
46
|
|
37
47
|
|
38
48
|
|