mysql where in maintain order group_concat code example

Example 1: group_concat mysql

GROUP_CONCAT(expr);

Example 2: group_concat in mysql

GROUP_CONCAT(eng_category_name SEPARATOR ',') as eng_category_name

Example 3: mysql where in maintain order group_concat

SELECT li.client_id, group_concat(li.percentage ORDER BY li.views ASC) AS views, 
group_concat(li.percentage ORDER BY li.percentage ASC) 
FROM li GROUP BY client_id