Using an OR in a MySQL Select If statement

It took a while to find the (sort of) obvious. I needed a Select statement that used the IF function and wanted the condition part to have an OR in it.

The standard syntax is:

if (condition, do this if true, do this if false)

eg

if (questions.type='F', concat(a,b,c), concat(a,b,c,d,e) )

with an OR

if (questions.type='F'||questions.type='G', concat(a,b,c), concat(a,b,c,d,e) )
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s