I could not find any information on forums so I am asking how would I set an index on the specific item that is in the atttribute of type set? And then use correct query that would use that index?

Example, I would want index on Audi of set Car.

Car set(‘Renault’,’Audi’,’BMW’).

POSSIBLE QUERIES??:

SELECT * FROM Table WHERE Car LIKE ‘%Audi%’;
Select * from Table where find_in_set(‘Audi’,Car);