I have a database and would like to know how do I search for the data by typing the complete result using where
Example:
ID NOME CODIGOS
1 | Joao | 9714,51,100
2 | Maria | 50,9714,88100
I wanted to make it return a where by searching for CODES
Search: 100
Show: Joao
Search: 9714
Show: Joao, Maria
I did so:
SELECT * FROM usuarios WHERE codigo like '%100%'
But the 100 searched is showing all results that have 100, so it returns 88100 and 100
What can I be doing?