Séparateur et GROUP_CONCAT [Résolu]

[okoweb]

Bonsoir,

Code :

1
2
3
4
5
6
7
 
SELECT R.libelleregion AS "Région", COUNT(D.iddpt) AS "Nb de circonscriptions", 
GROUP_CONCAT(CAST(D.iddpt AS CHAR), D.libelledpt ORDER BY D.libelledpt SEPARATOR ", " ) AS "Liste des circonscriptions"
FROM regions AS R
INNER JOIN departements AS D ON D.idregion = R.idregion
GROUP BY R.libelleregion
ORDER BY R.libelleregion

Mon pb est ici :

GROUP_CONCAT(CAST(D.iddpt AS CHAR), D.libelledpt ORDER BY D.libelledpt SEPARATOR ", " ) AS "Liste des circonscriptions"

Dans l'affichage des résultats, je souhaite insérer un "-" entre CAST(D.iddpt AS CHAR) et D.libelledpt. Cela est -il possible?

Merci d'avance...

[CinePhil]

Code :

GROUP_CONCAT(CONCAT(CAST(D.iddpt AS CHAR), '-', D.libelledpt) ORDER BY D.libelledpt SEPARATOR ", " )

[okoweb]

Envoyé par CinePhil

Code :

GROUP_CONCAT(CONCAT(CAST(D.iddpt AS CHAR), '-', D.libelledpt) ORDER BY D.libelledpt SEPARATOR ", " )

Exactement exact. Grand merci maitre.