Muzafar Muzafar -4 years ago 143
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?

Answer Source

I have used mysql function FIND_IN_SET() and I got the desired result through this function.

I got help from this tutorial.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download