I took an alternate solution for this using get_posts(), get_post_meta() to get the ids of my post type and the checkbox fields data and then comparing the meta with array_intersect() and in_array() for more accuracy.
This works better than the ‘LIKE’ operator which was giving me unexpected results.