Like mysql Date

Is there a way to do a like statement with query builder? I am trying to achieve

WHERE data.arrival LIKE ‘%2019-11-29%’ AND data.arcitycode = ‘bwi’.

The date and city code being url variables. The date I am searching is a datetime field, but I just need the date not the time.

thanks

Community Page
Last updated: