• Page:
  • 1

Query to search value in Comma Separated String

ONLINE

Query to search value in Comma Separated String

2 months, 1 week ago
Hello Team,

If you want to query to find particular value from a Comma Separated Field
 For e.g. 
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..


Thanks
Last Edit: 2 months, 1 week ago by Abhinav Jaiswal.
The following user(s) said Thank You: Vicky Jain, Deepesh Chang, Farhan Sahibole, Adarsh Surania, Rajat Pal
  • Page:
  • 1

Upcoming Events

No events found.

Who's Online