Muzafar Muzafar - 26 days ago 25
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

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

Comments