how to use where condition from stored data in array

Question

id | name | permission
1  | John | 1,4,3
2  | mike | 7,4,3
3  | sky  | 3,2,1

this is my database

now i have fetch select query with where condition

e.g. select * from friend where permission='4'

but i m not able fetch any data so what to do ?

Please help

Answer 1

Select * from friend where FIND_IN_SET('4',permission);