Bonsoir
J'essaye d'effectuer une requete sous phpMyAdmin:
select count(*) as max from video where video.pkVideo = (select rq2.tn from (select replace(rq1.tg,',',' ') as bh,rq1.idVideo as tn from(SELECT group_concat(tag.titre) as tg, video.pkVideo as idVideo FROM video INNER JOIN possede ON video.pkVideo = possede.pkEvideo INNER JOIN tag ON possede.pkEtag = tag.pkTag group by video.pkVideo) as rq1) as rq2 where rq2.bh like '%test%')
je ne peut pas effectuer la requete tandis si j'enleve les % cela marche
select count(*) as max from video where video.pkVideo = (select rq2.tn from (select replace(rq1.tg,',',' ') as bh,rq1.idVideo as tn from(SELECT group_concat(tag.titre) as tg, video.pkVideo as idVideo FROM video INNER JOIN possede ON video.pkVideo = possede.pkEvideo INNER JOIN tag ON possede.pkEtag = tag.pkTag group by video.pkVideo) as rq1) as rq2 where rq2.bh like 'test')
sauf que j'ai besoin des %
Partager