Using 'LIKE' in database explorer to select variables corresponding to substring.

Right so I have a SQL database that I'm analysing using the database toolbox and I want to select all variables corresponding to a particular date. Problem is that the dates currently include the time that the variable was measured, e.g. '2014-01-01 00:00:00'. I looked online and thought the following should work...

WHERE data.date LIKE '2014-01-01%'

to select variables where data.date starts with '2014-01-01'. When I implement this I don't get an error but nothing seems to be happening. Any ideas? Thanks in advance.