editing this sql statement

[wright67uk]

A month or so ago @Barand ever so kindly helped create an sql query for me...

 

 

SELECT month_table.month , IFNULL(AVG( yard ), 0) AS avscore FROM month_table LEFT JOIN `snag` ON month_table.month =

MONTH( STR_TO_DATE( sdate, '%d/%m/%y' ) ) AND club = '3 wood' AND user_id = $user_id AND YEAR = $year GROUP BY `month`";

 

Since doing this, I have changed the name of 'sdate' to 'date' and ive changed it from a varchar column to a date column with the format yyyy-mm-dd or 2013-07-31 .

 

 

Could anyone tell me how I can now update my query so that it works again?

[Barand]

SELECT month_table.month ,
   IFNULL(AVG( yard ), 0) AS avscore
FROM month_table
LEFT JOIN `snag` ON month_table.month = MONTH(date)
   AND club = '3 wood'
   AND user_id = $user_id
   AND YEAR(date) = $year
GROUP BY `month` ";

[wright67uk]

Great! Thankyou very much!