[MySQL] ORDER BY FIELD (SELECT compr

Voici ma requete:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
$sql=  "SELECT p.id_panier,
	       p.id_pdf,
	       p.code_prod,
	       r.titre_doc,
	       t.desc_type
	FROM paniers AS p, reldocs AS r, typedoc AS t, pdfdocs AS d
	WHERE id_panier =".$compilID." 
	AND p.id_pdf = r.id_pdf
	AND p.code_prod = r.prod_doc
	AND d.id_pdf = p.id_pdf
	AND d.type_pdf = t.code_type
	ORDER BY FIELD(id_panier, (SELECT comp_sort FROM compilheaders WHERE comp_id=".$compilID."))";

le souci est que comp_sort contient un string des id séparés par des virgules

ex: "121,12,569,58,25"

Comment faire ???

On m'a suggéré un debut de piste avec FIND_IN_SET

$sql= "SELECT p.id_panier, p.id_pdf, p.code_prod, r.titre_doc, t.desc_type FROM paniers AS p, reldocs AS r, typedoc AS t, pdfdocs AS d WHERE p.id_panier =".$compilID ." AND p.id_pdf = r.id_pdf AND p.code_prod = r.prod_doc AND d.id_pdf = p.id_pdf AND d.type_pdf = t.code_type ORDER BY FIND_IN_SET( p.id_pdf, (SELECT c.comp_sort FROM compilheaders AS c WHERE c.comp_id =".$compilID." ))";

ORDER BY FIELD (SELECT compr_sort FROM etc.)