I have a MySQL database with a number of columns (say column0 .. column19).
I want to select all rows of the database which satisfy a condition of the form:
column0 < value0 AND column1 < value1 AND ... AND column19 < value19.
You could use the below, but don't expect it'll perform particularly well!
WHERE (CASE WHEN column0 < value0 THEN 1 ELSE 0 END + CASE WHEN column1 < value1 THEN 1 ELSE 0 END + ... + CASE WHEN column19 < value19 THEN 1 ELSE 0 END) >= 15