Martin Gainty wrote:
Good Morning-
Good afternoon :-)
http://www.mysqlperformanceblog.com/2006/09/04/group_concat-useful-group-by-
extension/
I did'nt see your where clause ?
I'm probably missing your point here. But there's no "where clause"
because I want all records from the tickets tab
Baron Schwartz wrote:
I'm tempted to solve this using a view or two, but would like to know
if there's a better way.
GROUP_CONCAT() takes an optional DISTINCT modifier, and that might do
what you're looking for.
It sure does the trick. I'll use that, I was afraid that I was missing
somet
Hi,
Morten wrote:
Hi,
I'm trying to write a query which returns a single record which contains
concatenated values for referencing records:
SELECT tickets.id AS id,
CAST(GROUP_CONCAT(tags.name SEPARATOR ' ') AS CHAR) AS tags,
CAST(GROUP_CONCAT(events.value SEPARATOR ' ') AS CH
Hi,
I'm trying to write a query which returns a single record which contains
concatenated values for referencing records:
SELECT tickets.id AS id,
CAST(GROUP_CONCAT(tags.name SEPARATOR ' ') AS CHAR) AS tags,
CAST(GROUP_CONCAT(events.value SEPARATOR ' ') AS CHAR) AS text
FROM tic