in reply to mysql order and group_concat

This is completely off-topic so don't be surprise if your question is reaped, but (if i even understand your question correctly) perhaps you can try using HAVING instead of WHERE?

select `from`, group_concat(text) as con from `database` group by `from` having match text against ('windows xp') order by con desc

I must admit however that I really don't understand how match text against ('windows xp') works. :/

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)

Replies are listed 'Best First'.
Re^2: mysql order and group_concat
by Cassi (Novice) on Nov 22, 2008 at 19:53 UTC
    thanks for the reply but it actually don't work, I'm doing right now with 2 mysql calls :(. The first one select unique(from) and return the correct relevance, and the second one is doing the group_concat, It's not what a finally solution, I believe that must exist some way to make it all with only one mysql call.