I'm trying to grab transactions in a MySQL DB based on a field called 'updated_at', where the data looks like so (for yesterdays date, for example): 20160426 172600. I don't care so much about the time, it's just all transactions with the date value for yesterday.
This is the SQL statement I have at present, but it's grabbing 0 files.
SELECT updated_at FROM transactions WHERE date_format(curdate() - interval 1 day, '%Y%m%d') * 1 = created_at * 1
I know there is data with this value because I'm run thousands of records of the following statement
SELECT updated_at FROM transactions WHERE updated_at > '20160426'
Does anyone know the correct statement that would work, and where I'm going wrong please?