Select rows from table in Php/Mysql based on time or two dates?

[Justine40990]

hi i have players table in mysql .i need to select inactive players who have not played a match for 6 months in the league .for example ->\[code\]select * from players where player (matchplayed == true && (in last 6 months condition));\[/code\]i am newbie in mysqlso will like some help how to deal with time .