How to add an IF condition in MySQL?

Question

MySQL

There is such a sign:

I want to make such a request. If date is less than today, then UPDATE quey to value 1000, and then the usual SELECT id, date, etc. otherwise, just SELECT
But no matter how I twist with conditions and subqueries, it doesn’t work out, for example:
SELECT IF(`date` < NOW()) `id`, `query`, `date`

Answer 1

Update.... where query from your if? So not satisfied? And if it doesn’t fit at all, you can use built-in functions and describe anything there.

Answer 2

As far as I remember IF(Exp, true, false )