1. Home
2. sqlite/php - order by 'input order' - with imploded query

126 votes

0 answers

sqlite/php - order by 'input order' - with imploded query

Get the solution ↓↓↓

Solution:

In SQL, tables always are unordered; there is no guarantee that a query uses any specific order.

If you want to get the rows in a specific order, you have to explicitly sort them by using ORDER BY in the query.

If there isn't some table data that you can use directly for sorting, you have to use a CASE expression to map the table values to some values usable for sorting:

SELECT ...
ORDER BY CASE WordColumn
         WHEN '隔' THEN 1
         WHEN '山' THEN 2
         WHEN '买' THEN 3
         WHEN '老' THEN 4
         WHEN '牛' THEN 5
         END;
Copy code

Undefined asked

2023-06-8

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2023-06-8

Link To Source
Link To Answer People are also looking for solutions of the problem: http failure during parsing for

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

20 php - In a Twig template {{0 in ['a', 'b', '99']}} returns 1. WHY?

978 php - Using JQuery UI's sortable('serialize') after loading data in via .load();

495 How to check whether $_GET['id'] is set and it's not empty using php

556 PHP + SQL - Using SQL Server 'Create To' scripts to create tables through PHP

169 php - Why does $_SERVER['HTTP_REFERER'] still show original referrer?

549 php - Avoiding including abstract class in a general 'bootstrap' file

186 php - Getting "Call to undefined function: 'define': in phalanger web site

567 php - Nested mysql_query() - Resets first result's pointer?

551 php - WooCommerce: Custom function adding free product - Cart page getting broken for orders up to 3000

570 php - Filter content from mysql db with checkboxes using jQuery?

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

HTML

HTML (English "hyper text markup language" - hypertext markup language) is a special markup language that is used to create sites on the Internet. Browsers understand html perfectly and can interpret it in an understandable way. In general, any page on the site is html-code, which the browser translates into a user-friendly form. By the way, the code of any page is available to everyone.
https://www.w3.org/html/