I have a district table, in which we store user’s preferred districts in district table district_id (varchar(250)) field(column). Value stored in this field is like 1 2 5 6 1 by using \n. So please tell me, how can i search in this specific column?
I have used mysql function FIND_IN_SET() and I got the desired result through this function.
I got help from this tutorial. http://www.w3resource.com/mysql/string-functions/mysql-find_in_set-function.php