I have a simple MySQL statement:

```
SELECT q1, COUNT(q1) FROM results WHERE q1 IN ('1','2','3');

```

Currently there are only results for 1 and 3 - results are:

```
1 = 6
3 = 7

```

But what I need is for MySQL to bring back a result for 1,2 and 3 even though 2 has no data, as this:

```
1 = 6
2 = 0
3 = 7

```

Any ideas?