By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tablename (`field_name` VARCHAR(6), `field_id` INTEGER);
INSERT INTO tablename (`field_name`, `field_id`) VALUES
('A (AB)', '1'),
('A', '2'),
('B (AB)', '3'),
('B', '4'),
('C', '5'),
('D (AB)', '6'),
('D', '7');
SELECT TRIM(REPLACE(t.field_name, '(AB)', '')) field_name,
COUNT(*) field_amounts
FROM tablename t
GROUP BY 1
HAVING SUM(t.field_name LIKE '%(AB)%') > 0;
| field_name | field_amounts |
|---|---|
| A | 2 |
| B | 2 |
| D | 2 |