Searching boolean data

let say i have data in boolean such as follows:

termites-yes/no
rats-yes/no
bees-yes/no

but when i search or filter a termites on my list i cant get any results coz termites in my database is in boolean(yes/no). is there any workaround on this? thanks.

Firstly, you’re probably better off not using Boolean values for this (use an option set list instead.)…

But to search for Things who’s Termites is yes - just do a search for things who’s termites is yes.

customers sometimes needs to choose multiple pest so list is not the option. my work around is i converted boolean into formatted text, is this good or is there any right way of doing it.