Hi,
You can try the following.
Store the result of your query into a temporary table, say tp, with two
columns tc (ticketID) and pname (pipelineName).
Run the following query :
select concat("select @c:='';","select tc,
(@c:=concat_ws("","",@c,pname)) as x, length(@c) from tp where tc=",
tc," order by 3 desc limit 1;") from tp group by tc ;
and store the result into another variable (say, sth).
Execute the query in sth.
You should get your results as the column x in the result set.
SB
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
