I have a table which stores keywords as a comma separated list. The records are like
1) Ad Name | car rentals, car advertising
2) Ad Name | car, bmw, bike
I would want to search for 'car' and would like to have only the second record listed and not the first record. But our usual query where keyword like '%car%' wouldn't work here. Is it possible to split these keywords in the query itself and then make it work?