好资源导航 » 文章资讯 » 执行MySQL ORDER BY关键字匹配吗？

执行MySQL ORDER BY关键字匹配吗？

2024-04-24 03:20:03 449

为此，让我们创建一个表，插入一些值并使用ORDERBYCASE。让我们首先创建一个表-

mysql> create table DemoTable602 (GameName text);

使用插入命令在表中插入一些记录-

mysql> insert into DemoTable602 values('Candy cash game');
mysql> insert into DemoTable602 values('Pubg');
mysql> insert into DemoTable602 values('cash Candy game');
mysql> insert into DemoTable602 values('subway');

使用select语句显示表中的所有记录-

mysql> select *from DemoTable602;

这将产生以下输出-

+-----------------+
| GameName        |
+-----------------+
| Candy cash game |
| Pubg            |
| cash Candy game |
| subway          |
+-----------------+
4 rows in set (0.00 sec)

以下是执行MySQLORDERBY关键字匹配的查询-

mysql> select *from DemoTable602
   order by
      CASE WHEN instr(GameName, 'Candy') = 0 then 1 else 0 end,
      instr(GameName, 'cash') desc;

这将产生以下输出-

+-----------------+
| GameName        |
+-----------------+
| Candy cash game |
| cash Candy game |
| Pubg            |
| subway          |
+-----------------+
4 rows in set (0.00 sec)

返回顶部
3162201930
czq8825@qq.com

执行MySQL ORDER BY关键字匹配吗？

热门推荐

随机推荐