MySQL user's Conference
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?
More information about the developers