Postgres 11

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tbl (id serial , description text);
INSERT INTO tbl(description) VALUES
   ('HAB')
 , ('DHAB,RAB,DAB')
 , ('HAB,RAB,DAB')
 , ('RAB,HAB,')
 , ('RAB,HAB,DAB');

CREATE INDEX ON tbl USING gin (string_to_array(description, ','));
5 rows affected

SELECT *,string_to_array(description, ',')
FROM   tbl
WHERE  'HAB' = ANY (string_to_array(description, ','));


id
description
string_to_array


1
HAB
{HAB}

3
HAB,RAB,DAB
{HAB,RAB,DAB}

4
RAB,HAB,
{RAB,HAB,""}

5
RAB,HAB,DAB
{RAB,HAB,DAB}


SELECT *
FROM   tbl
WHERE  string_to_array(description, ',') @> '{HAB}'


id
description


1
HAB

3
HAB,RAB,DAB

4
RAB,HAB,

5
RAB,HAB,DAB

id	description	string_to_array
1	HAB	{HAB}
3	HAB,RAB,DAB	{HAB,RAB,DAB}
4	RAB,HAB,	{RAB,HAB,""}
5	RAB,HAB,DAB	{RAB,HAB,DAB}