How to Make two or more Select categorized in the same query

Question

I need to take all words with 'A' and play 'Palavrascoma' and all words with 'B' and play Palavrascomb, and can have C, D E... The closest so far was that, but only with the first.

SELECT
    w1.wd as PalavrasComA,
    w2.wd as PalavrasComB
From ptbr as w1, ptbr as w2 

where left (w1.wd, 1) = 'a'

and left (w2.wd, 1) = 'b';

Answer 1

If you want to bring them all in one query fixed can do as in the example:

SELECT COUNT(CASE WHEN left(w.wd, 1) = 'a' THEN 1 END) AS a,
       COUNT(CASE WHEN left(w.wd, 1) = 'b' THEN 1 END) AS b,
       COUNT(CASE WHEN left(w.wd, 1) = 'c' THEN 1 END) AS c
  FROM ptbr w

If you want to return the words:

SELECT left(w.wd, 1) AS letra,
       GROUP_CONCAT(w.wd SEPARATOR ',') AS palavras,
       COUNT(CASE WHEN left(w.wd, 1) = 'c' THEN 1 END) AS c
  FROM ptbr w
 GROUP BY left(w.wd, 1)

If you want to separate by columns:

SELECT GROUP_CONCAT(IF(left(w.wd, 1) = 'a', w.wd ,'') SEPARATOR ', ') AS palavrasComA,
       GROUP_CONCAT(IF(left(w.wd, 1) = 'b', w.wd ,'') SEPARATOR ', ') AS palavrasComB,
       GROUP_CONCAT(IF(left(w.wd, 1) = 'c', w.wd ,'') SEPARATOR ', ') AS palavrasComC
  FROM ptbr w

Or if you just want the first word:

SELECT MIN(IF(left(w.wd, 1) = 'a', w.wd, NULL)) AS palavrasComA,
       MIN(IF(left(w.wd, 1) = 'b', w.wd, NULL)) AS palavrasComB,
       MIN(IF(left(w.wd, 1) = 'c', w.wd, NULL)) AS palavrasComC,
  FROM ptbr w