computer:2:know

mysql sql queries

 #montly birthdays

select * from actual where substring_index(substring_index(geburtsdatum,'-',2),'-',-1)=11 order by substring_index(geburtsdatum,'-',-1),substring_index(geburtsdatum,'-',1)



#young people

select * from actual where substring_index(geburtsdatum,'-',1)>1989 and substring_index(geburtsdatum,'-',1)<1994 and aktiv = 'TRUE' order by substring_index(geburtsdatum,'-',1), name

Computer and IT knowledge - things to know

mysql sql queries