Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > PHP读取数据库并按照中文名称进行排序实现代码_php技巧

PHP读取数据库并按照中文名称进行排序实现代码_php技巧

WBOY
Release： 2016-05-17 09:06:58
Original
1074 people have browsed it

有时候我们读取数据库输出的时候可能会需要按照中文用户名的方式进行排序，传统的MySQL查询代码如下：

复制代码 代码如下:

$sql="SELECT * FROM users";//传统查询方式

按照中文用户名进行排序的MySQL查询代码如下：
复制代码 代码如下:

$sql="SELECT * FROM users ORDER BY CONVERT(name USING gbk)";//按照中文用
Related labels：
sort
source：php.cn
Previous article：php数组去重的函数代码_php技巧 Next article：php获取服务器信息的实现代码_php技巧
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Regular expression to match words I have a script where I am trying to match new job names with existing job names in a data...
From 2024-04-06 21:24:04
0
1
606
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
MySQL gets data from multiple tables I have a eg_design table which contains the following columns: and eg_domains table which ...
From 2024-04-06 18:42:44
0
2
479
Laravel 8 - How to redirect /{editable_text} route to /{user} route I've been trying to create a redirect route to lead me to a user profile. The redirect rou...
From 2024-04-06 17:26:11
0
1
410
The entity warehouse extends JpaRepository<Entity, Id> and JpaSpecificationExecutor<Entity>, and EntitySpec extends Specification<Entity> This is my endpoint http://localhost:8080/country/all replies are ok for all countries and...
From 2024-04-06 17:11:03
0
1
421
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template