<div>
<div class="content wysiwyg-content">
I'd like to do a sql (MySQL) query where I can compare one numeric field with the sum of 5 other numeric fields.<br />
<br />
Specifically, like:<br />
<br />
SELECT * from table where table.a + table.b + table.c + table.d + table.e &lt;&gt;&nbsp;table.f<br />
<br />
Can this be done &amp;&nbsp;what is the right syntax?<br />
<br />
Thanks
</div>
</div>


I'd like to do a sql (MySQL) query where I can compare one numeric field with the sum of 5 other numeric fields.

Specifically, like:

SELECT * from table where table.a + table.b + table.c + table.d + table.e <> table.f

Can this be done & what is the right syntax?

Thanks

SQL Statement

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.