MySQL字母顺序 [英] mysql alphabetical order

问题描述

我正在尝试按字母顺序对mysql数据进行排序，例如

i am trying to sort mysql data with alphabeticaly like

A | B | C | D

A | B | C | D

当我单击B时，此查询就会运行

when i click on B this query runs

从用户订单中按"b"选择名称

select name from user order by 'b'

但是显示所有以a或c或d开头的记录的结果我只想显示以b开头的记录

but result showing all records starting with a or c or d i want to show records only starting with b

感谢帮助

推荐答案

我只想显示以b开头的记录

i want to show records only starting with b

select name from user where name LIKE 'b%';

我正在尝试按字母顺序对MySQL数据进行排序

i am trying to sort MySQL data alphabeticaly

select name from user ORDER BY name;

我正在尝试按反向字母顺序对MySQL数据进行排序

i am trying to sort MySQL data in reverse alphabetic order

select name from user ORDER BY name desc;

这篇关于MySQL字母顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！