Try

SELECT *
FROM <table>
WHERE date LIKE '%/09/%'