SELECT 
    something
FROM
    some_table
WHERE 
    TO_DAYS(NOW()) - TO_DAYS(date_column) = 10;