Muzafar Muzafar - 5 months ago 74
MySQL Question

\n Separated Search in Column

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.