Query report - date

Hi all,

I need a help with MySQL to make a where clause that shows me only the lines where CompletedTime = CompletedTime - 1 day.

I know that in Oracle would be something like this:

(TRUNC(wo.crompletedime)>TRUNC(SYSDATE)-1)

The rest of the query is ready, I'm only stuck in this where clause.

My SQL is Linux Based.

Tks in adv,
Thaiz Cabral