Asksearch_php.cn

Community Learn Tools Library Leisure

English

Popular searches：
PHP
MySQL
jquery
HTML
CSS

Why does the order change after mysql uses group_concat?

Since the fields in the two tables contain a one-to-many relationship, the group_concat function was used to splice multiple pieces of data when constructing the view to reduce the amount of data. However, after splicing, it was found that the original order had changed. For example: original data: ...

天蓬老师 2017-05-18 10:49:30

GROUP_CONCAT using the CASE statement can produce multiple outputs.

I have a SQL query that contains the following line of code: GROUP_CONCAT(CASE WHEN t3.ship=1 AND t4.item=0 THEN t2.item_name END ORDER BY item_id SEPARATOR '') AS `MyItemList`. The current output is: Lamp. It's working fine, but I want the item number stored in the item_no column to be displayed in...

P粉652495194 2023-07-25 08:17:06

SQL - ORDER BY sorting is incorrect

I have a question, it works fine. In the last step, I want it to sort the entire table DESC based on the number of items in the "Item List" column, but it doesn't work. SELECTt8.usernameAS'Username',GROUP_CONCAT(CASEWHENt1.dup=1ANDt2.stat=0ANDt5.item_name='lamp'THENitem_idENDORDERBYitem_id...

P粉301523298 2023-09-06 18:42:46