mysql - Find all kids born on Friday -
how can find dates in 1 table - fridays - can show information in table?
i taking information ads.date
.
look @ mysql function dayofweek()
select * ads dayofweek(ads.date)=6
dayofweek() returns weekdaynumber 1-7 1 sunday. if want born on friday have filter on dayofweek() = 6
Comments
Post a Comment