Is php processing a paging sorting in mysql?

Let me ask you a question. Suppose my record is like this: {code ...} I want to display the result after sorting, and sort the same name and a large number of names at the top, as shown in the following code: {code ...} if there is no paging, I know how to implement it, but there is a problem after paging. How can I solve it with SQL? If... let me ask you a question. Suppose my record is like this:

Name num php 1 php 2 java 3 java 4 java 5

I want the sorting result to be displayed as follows:

Java 3 java 4 java 5 php 1 php 2

IfNo Paging, I know how to implement it, but there is a problem after the page appears. How can I solve it using SQL? If not, how can I solve it in the program? Please give directions!

Reply content:

Let me ask you a question. Suppose my record is like this:

Name num php 1 php 2 java 3 java 4 java 5

I want the sorting result to be displayed as follows:

Java 3 java 4 java 5 php 1 php 2

IfNo Paging, I know how to implement it, but there is a problem after the page appears. How can I solve it using SQL? If not, how can I solve it in the program? Please give directions!

Use order

Select * from table order by name limit 0, 10