2009-04-14 SQLメモ ヒビメモ SELECT sum(amount) FROM `sample` WHERE name like "aaa" and date like "2009-04%" nameが「aaa」でdateが「2009-04*」のamountの合計。