minte9
LearnRemember



GROUP_CONCAT 

 
SELECT <span class='keyword_code'>GROUP_CONCAT</span>(ancestor) AS ancestors FROM catg_path WHERE descendant=7 
//ancestor: 2,5,7

SELECT GROUP_CONCAT(ancestor SEPARATOR ' / ') AS ancestors FROM catg_path WHERE descendant=7
//ancestors: 2 / 5 / 7

SELECT GROUP_CONCAT(ancestor ORDER BY ancestor DESC SEPARATOR ' / ') AS ancestors 
            FROM catg_path WHERE descendant=7 
//ancestors: 7 / 5 / 2

CONCAT_WS 

 
SELECT <span class='keyword_code'>CONCAT_WS</span>(" / ", catg, subcatg) FROM catg WHERE catg='programming'; // jQuery / MySQL / PHP

CONCAT 

 
// returns NULL if any argument is NULL

SELECT CONCAT('My', 'S', 'QL'); 

// Output: 'MySQL'



  Last update: 249 days ago