If you want to query to find particular value from a Comma Separated Field
If you want to search BANGLORE in NASHIK,BANGLORE,MUMBAI
then you can use MySQL function find_in_set()
You can use it as below.
SELECT * from table_name WHERE find_in_set('BANGLORE',city_field_name);
Note: Since it does not use indexing, query would run slow on large tables..
Last Edit: 7 months, 1 week ago by Abhinav Jaiswal.