Re: Stored Procedure .. IF statement condition problem

[Rick James]

You can construct a SELECT, PREPARE it, and EXECUTE it.
In the construction of the SELECT, you can CONCAT a string such as "<=" in the middle of an expression:

... CONCAT("SELECT ... WHERE CalculatedPercent_val", ValidationOperator_val, " AcceptableStats_val")

But that will work only if you get CalculatedPercent_val once, not from the row with the values. In that case, consider:

WHERE CASE
        WHEN ValidationOperator_val = '>=' THEN CalculatedPercent_val >= AcceptableStats_val
        WHEN ValidationOperator_val = '<=' THEN CalculatedPercent_val <= AcceptableStats_val
     END