MySQL user's Conference

Gervase Markham gerv at mozilla.org
Sat Apr 26 10:39:35 UTC 2003


> *cough* votes/keywords cache *cough*. Which, btw, is where a function to
> get the sorted list of keywords from a bug_id (for display) would be
> very useful. We can't use a join because that won't sort it, so we could
> just SELECT bug_id, get_keyword_string(bug_id), .... where
> get_keyword_string just concatentates SELECT name FROM keywords WHERE
> bug_id=aBugId ORDER BY UPPER(name), or something along those lines.

Shouldn't the display templates be responsible for sorting them anyway? 
So we can use a JOIN?

Gerv




More information about the developers mailing list