SELECT SUM(IF(user.name LIKE '%bob%',1,0)) AS `total_bobs`,
IF condition THEN statements; ELSE else-statements; END IF;