Combine multiple row data into single column by a single line sql query

[rishikesh]

Hello,

i use following query to display ticket's all status in one line
rather multi-line.

select ticket,group_concat(newvalue) from ticket_change
where
ticket=75 and field='status'

Output of query is

75 | new,assigned,closed

it means i combine multiple row data into single column by a sql
query.

But when i put above query in trac for report generation, it raise
error

" Report execution failed: no such function: group_concat "

is any other alternative way to get above result using sql query ??

Thanks,
Rishikesh