If Statement

[pantoner]

I am trying to convert my MS Access database to MYSql.

I have some queries where I create a column based on the results of an IF statement.

In Access the query goes something like this:

SELECT table.column_A, table.column_B, IF(table.column_B = "1", 0, IF(table.column_B = "2", [table.column_C1], IF(table.column_B = "3", [table.column_C1]+[table.column_C2],0))) AS column_D
FROM table

How do a write this for MySql?

[code green]

The IF statement is fine for MySql.
Remove the square brackets or replace them with backticks

[pantoner]

Here is a query that I tried in MYSQL that doesn't work. It says that there is an error in my SQL syntax near the IF statement.

What is wrong with it?

SELECT
`1stcalldivided`.TN,
`1stcalldivided`.RD,
`1stcalldivided`.RN,
`1stcalldivided`.HNa,
`1stcalldivided`.1ston,
IF (`1stcalldivided`.1ston = "1", "3", "2") AS final
FROM
`1stcalldivided`

[code green]

I really can't see anything wrong.
But technically this is an IF function not an IF statement. The two differ
The only possibilities I can think of are:
The IF function is not supported in older MySql versions.
You have a missing comma or backtick or one too many.
The follwing nested IF works fine for me

SELECT `product_id`, `code`,IF(`stock_level`<1,
     IF(`products`.`lead_time_id`=1,'YES',`lead_time`),'YES') 
    AS available 

[pantoner]

I am using MYSQl 5.0.

I did some reading and I think that I have to put the IF function in a stored procedure or a function. What version of MYSql can use the IF function right in the query the way you are doing it, and the way I have been doing it in MS Access?

I do not have the patience or desire to figure out how to make the stored procedure in MYSql 5.0 work.

[code green]

It is a Control Flow function and doesn't need to be in a stored procedure.
What about trying the CASE statement instead?

SELECT CASE WHEN 1>0 THEN 'true' ELSE 'false' END;
'

will return 'true

[pantoner]

Thanks for the encouragement. I got the if statement to work in my query.