SELECT *, group_concat (, concat_ws (X, 'sku ', 'quantity-purchased'),), group_concat (, 'Order _ id ',) FROM 'Sale _ orders 'WHERE 'shipment' 0 SQL query sorting problem
SELECT *, group_concat ('', concat_ws ('X', 'sku ', 'quantity-purchased'),''), group_concat ('', 'Order _ id ', ') FROM 'sale _ orders' WHERE 'shipents' = 0 AND 'number' = $ id group by 'recipient-name ', 'ship-address-1 'Order BY 'sku'
Can group_concat ('', concat_ws ('X', 'sku ', 'quantity-purchased'),'') be sorted ???
The query results are as follows:
Ship name sku-quantity
001-01 wang A0015-00-04-23 X 1
002-02 liu A0041-00-WW-25 X 1, A0042-00-AC-25 X 1
003-03 li A0041-00-WW-25 X 1, A0256-00-O6-34 X 1, A0042-00-AC-25 X 1
004-04 fang A0042-00-AC-25 X 1, A0041-00-WW-25 X 1, A0217-00-SI-33 X 1
The sku-quantity field is sorted by SKU. I want the SKU of each record to be sorted as well.
------ Solution --------------------
FROM 'Sale _ orders'
Change
FROM (select * from 'sale _ orders 'Order by 'sku ') T
