• Top of my list is GROUP_CONCAT, closely followed by REPLACE with wildcards.