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

Popular posts from this blog

django - (fields.E300) Field defines a relation with model 'AbstractEmailUser' which is either not installed, or is abstract -

matlab - error with cyclic autocorrelation function -

php - Using grpc in Laravel, "Class 'Grpc\ChannelCredentials' not found." -