I am having the following mysql table 

```
id  status
------------
1   available
2   hold
3   available
4   so-hold
5   so-hold
6   hold
7   hold
8   available

```

When I use `GROUP BY` on `STATUS` coloumn I got the following :

```
count(id)   status
---------------------
3           available
3           hold
2           so-hold

```

Under `status` coloumn **'hold'** and **'so-hold'** belongs to the same category so I need count in the following manner : 

```
count(id)   status
---------------------
3           available
5           hold

```

Following is the MySQL query that I am using currently :

```
SELECT count(id), status FROM `inventory_master` GROUP BY status

```