This question already has an answer here:
- MySQL: Sort GROUP_CONCAT values 2 answers
Im in a situation where i need to sort date in concat within group_concat while my query is running fine
SELECT
report.`Name`,
GROUP_CONCAT(
CONCAT(
"[",
DATE(report.Date),
',',
report.ProductPrice,
"]"
)
) AS ProductPrice
FROM report
GROUP BY report.Name ;
Aucun commentaire:
Enregistrer un commentaire