For me the following query works without a problem:
SELECT <col1>, <col2>, <col3> FROM `tablename` where date like "2025-03-06%" limit 20