MYSQL syntax - how to use where query with conditional statement in query

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65891028/mysql-syntax-how-to-use-where-query-with-conditional-statement-in-query

Answer 1

Since SUCCESS_LOG is not a real field, you need to use HAVING to check on it.

HAVING `SUCCESS_LOG` LIKE 'NO'

Though, in this query, I would just check your MAIN.PROCESS (again). That would probably be more efficient.

WHERE `MAIN`.`PROCESS` = 0