[Solved] Select value from single value from multiplie vlaue column in mysql

by


Used LIKE query. Please try this query:-

SELECT * 
FROM Datauser 
WHERE Plans LIKE "109" OR Plans LIKE "109,%" OR Plans LIKE "%,109" 
OR Plans LIKE "%,109,%"

Which simply means that there can be 4 conditions in the column:

plans column has only ‘109’ in it, or ‘,109,’ in it or ‘109,’ in it, or ‘,109’ in it.

1

solved Select value from single value from multiplie vlaue column in mysql