SQL Rearange data from multiple cells into one I am trying to create a view that groups by a particular column (let's say BRAND) and all instances of a 2nd column (let's say COLOR) for each BRAND, grouped in a single cell and separated by semicolon. It's hard for me to put it in words but this is what I am looking for:  FROM THIS TABLE  |BRAND  |COLOR  | |-------|-------| |TOYOTA |BLUE   | |NISSAN |BLUE   | |FORD   |BLUE   | |NISSAN |RED    | |NISSAN |GREEN  | |FORD   |RED    | -----------------   TO THIS VIEW  |BRAND  |COLOR          | |-------|---------------| |TOYOTA |BLUE           | |NISSAN |BLUE;RED;GREEN | |FORD   |BLUE;RED       | |-------|---------------|   I wish I could provide code but I have not come up with any ideas.
Can I concatenate multiple MySQL rows into one field? Using MySQL, I can do something like:  SELECT hobbies FROM peoples_hobbies WHERE person_id = 5;   My Output:  shopping fishing coding   but instead I just want 1 row, 1 col:  Expected Output:  shopping, fishing, coding   The reason is that I'm selecting multiple values from multiple tables, and after all the joins I've got a lot more rows than I'd like.  I've looked for a function on  and it doesn't look like the CONCAT or CONCAT_WS functions accept result sets.  So does anyone here know how to do this?
Category of profinite groups Firefox: Downloading files with drag and drop Using TIPA with fontspec How can continue the equation of the rectangle red in next line?   \documentclass[11pt,a4paper,twocolumn]{article}  ...  \begin{equation*}     \left| \dot{r} \right| =     \sqrt{{- \, {e}^{-t} \left( \cos t + \sin t \right)}^{2} \, + \, {{e}^{-t} \left( \cos t + \sin t \right)}^{2} \, + \, {(- \, {e}^{-t})}^{2}} \end{equation*} Why do I have to specify runat="server" on all my ASP.NET controls when it is a mandatory attribute and server is the only option available in my limited knowledge of ASP.NET, and I get an error if I don't use it?  I do understand that I can optionally use it on my HTML tags, and I do understand the client/server paradigm and what it is actually specifying.  Is it a redundant tag that could just be implied by the control being an ASP.NET control, or is there an underlying reason? Polynomials, prove exercise question about question There is a polynomial P with integer coefficients and with pairwise different integers $a,b,c$ . Prove that it is not possible for $P(a) = b$, $P(b)=c$, $P(c) = a$  First off I don't understand "pairwise different" part - what does it mean ,can you show me this as an equation? After that I'd like to get a hint in case I don't make it. + I'd prefer to have hints/answers written more algebraically without $\sum$ etc. (It helps me get better understanding what's going on under the hood) How can I convert an std::string to a char* or a const char*? I've read a new study which suggests that yawning may help you keep a cool head. Also, the findings might hold some hope for sufferers of insomnia, migraines, and even epilepsy.  Is there any conclusion about what the function of yawning is and why do we yawn? Does measurement, quantum in particular, always increase the total entropy? Where do deleted items go on the hard drive? Recommendations for good Newtonian mechanics and kinematics books What are some good books for learning the concepts of Kinematics, Newton laws, 2D Motion of Object etc.? How to automatically generate N "distinct" colors? Can I pickle a python dictionary into a sqlite3 text field? Any gotchas I should be aware of?  Can I store it in a text field, or do I need to use a blob? (I'm not overly familiar with either pickle or sqlite, so I wanted to make sure I'm barking up the right tree with some of my high-level design ideas.) Disable the "You've gone full screen" notification in Chrome Where is Jon going? Apple Magic Trackpad multitouch configuration Where do ultra-high-energy cosmic rays come from? Physicists have detected an amazing variety of energetic phenomena in the universe, including beams of particles of unexpectedly high energy but of unknown origin. In laboratory accelerators, we can produce beams of energetic particles, but the energy of these cosmic rays far exceeds any energies produced on Earth. So my question is, from where do these  come from? "...his parents' dream of *him* achieving a Cambridge degree." What is the function of "him" here? What are the practical differences between 256-bit, 192-bit, and 128-bit AES encryption? What longest time ever was achieved at holding light in a closed volume? For what longest possible time it was possible to hold light in a closed volume with mirrored walls?   I would be most interested for results with empty volume but results with solid-state volume may be also interesting.