mysql GROUP BY产品

table:
id   p_name      p_price
1    tan           1
2    soap          1
3    pro tan 01    2 
4    pro tan 02    3 
5    pro tan 03    4

pro tan

product name     price
tan                1
soap               1
pro tan            9

$q_products = $db->query(\"SELECT * FROM p_products 
                          GROUP BY p_name 
                          HAVING LIKE \'pro tan%\'\"); 
// follow by while loop for echoing

select s.p_name, sum(s.p_price) 
from 
  (select left(p_name, 7) as p_name, 
   p_price from products) s
group by s.p_name;

$q_products = $db->query(\"SELECT * FROM p_products GROUP BY p_name having p_name LIKE \'pro tan%\'\");