Skip to content

Instantly share code, notes, and snippets.

@phillipadsmith

phillipadsmith/gist:110198

Created May 11, 2009 21:27
Show Gist options
  • Save phillipadsmith/110198 to your computer and use it in GitHub Desktop.
Save phillipadsmith/110198 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT phillipadsmith_bricbugs.bugs.bug_id,
phillipadsmith_bricbugs.longdescs.bug_id,
phillipadsmith_bricbugs.bugs.bug_status,
phillipadsmith_bricbugs.bugs.op_sys,
phillipadsmith_bricbugs.bugs.priority,
phillipadsmith_bricbugs.bugs.short_desc,
phillipadsmith_bricbugs.bugs.bug_severity,
GROUP_CONCAT(phillipadsmith_bricbugs.longdescs.thetext ORDER BY phillipadsmith_bricbugs.bugs.bug_id SEPARATOR '--')
FROM phillipadsmith_bricbugs.bugs
INNER JOIN phillipadsmith_bricbugs.longdescs
ON phillipadsmith_bricbugs.bugs.bug_id = phillipadsmith_bricbugs.longdescs.bug_id
WHERE phillipadsmith_bricbugs.bugs.bug_status LIKE '%NEW%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment