<div>
Yes! Thank you! I knew it was simple.
</div>


<div>
And SQL Server syntaxas a bonus:<br />
<br />
SELECT CASE WHEN a = 0 THEN 100 ELSE a END + b AS sum FROM myTable WHERE 1=1<br />

</div>


And SQL Server syntaxas a bonus:

SELECT CASE WHEN a = 0 THEN 100 ELSE a END + b AS sum FROM myTable WHERE 1=1


<div>
<div class="content wysiwyg-content">
Say I have the query:<br />
SELECT (a + b) AS sum FROM myTable WHERE 1<br />
<br />
I want to do something like:<br />
SELECT ((IF a = 0 RETURN 100 ELSE RETURN a END IF) + b) AS sum FROM myTable WHERE 1<br />
but that obviously doesn't work. I just want to add a new value to b that i want if a = 0.<br />
<br />
I need to do this in mysql so i can sort results.<br />
Is there an easy way to do this?<br />

</div>
</div>


Say I have the query:
SELECT (a + b) AS sum FROM myTable WHERE 1

I want to do something like:
SELECT ((IF a = 0 RETURN 100 ELSE RETURN a END IF) + b) AS sum FROM myTable WHERE 1
but that obviously doesn't work. I just want to add a new value to b that i want if a = 0.

I need to do this in mysql so i can sort results.
Is there an easy way to do this?


IF statement in sql query?

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.