Like and quotes

[mikerh9]

I want to search in the string for timestamp(06/282005).

DATA_FORMAT(now(), '%m%d%y') as follow where like '%follow%'

OR why this doesn't work?

field like ''%DATA_FORMAT(now(), '%m%d%y')%'

This code above doesn't work... it search for 'follow' not for timestamp

[edcellgavin]

how bout this
... where date_format(datefield, '%Y%m%d') = date_format(now(), '%Y%m%d') ...