mysql字母顺序

Question

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

一个 |乙 |丙 | D

当我点击 B 时，这个查询运行

select name from user order by 'b'

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

感谢帮助

Answer 1

i want to show records only starting with b

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

i am trying to sort MySQL data alphabeticaly

select name from user ORDER BY name;

i am trying to sort MySQL data in reverse alphabetic order

select name from user ORDER BY name desc;