Perhaps pass in a "separator" string arg, default to '' and do:
GROUP_CONCAT(DISTINCT h.hostid, separator)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I have a function that I built that returns a string that is really a
comma separated list of values (below). I would like to use that
returned value in an IN clause in sql. :
select * from hosts where hostid in (getHosts(10014));
The function:
CREATE FUNCTION getUserHosts(userID BIGINT(2
