How to check day of the week being 1,3,5

-1

Galera,

I have a field in my table that holds the day of the month, example

But in the same field I am recording the information like this: 1,2,3,5,22

Today is 22 DAY (NOW ()) = 22

See that in my field the day is 1,3,5 as it is today 22 should bring the record.

How can I check my field in mysql? Split? If so, how can I use it?

    
asked by anonymous 22.06.2017 / 16:43

1 answer

4

Use like

SELECT * FROM tabela WHERE campo LIKE "%5%"
    
22.06.2017 / 16:46