Mysql query, selecting two values in one field

enter image description here

In the table above table ‘sent’ I use, among other things, two fields: ‘opened’ and emailnumber.

I’m looking for a mysql query that the people who opened email number 1 and/or email number 2 one or more times

So in the example it would be everyone, except Fred I think it’s simple, but I can’t find the solution

Answer

SELECT name
FROM table
GROUP BY name
HAVING SUM(open > 0);