Re: How to replace in syntax when calling stored procedure?

[Devart Team]

You can use this one -

SELECT
  COUNT(DISTINCT SN)
FROM
  tester
WHERE
  Date > STR_TO_DATE(CONCAT(yr, mth, '01'), '%Y%m%d') AND Date < STR_TO_DATE(CONCAT(yr, mth, '01'), '%Y%m%d') + INTERVAL 1 MONTH;

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/