SQL Statements from Access to MySQL

[Carlo Uy Matiao]

I'm currently shifting my Access Database into MySQL. I have some Access SQL Statements which I can't make it work with MySQL. Here are they:

1.) IIF() - What's the equivalent for the IIF function on MySQL. The IIF() function works on MS Access but not on MySQL.


2.) Parameters - I have some where clause where I need to specify the value on runtime. So I need to use parameter variable on this. On Access, we just need to add the semicolon(:) before the word so we it's consider a parameter and we can specify the value on runtime. How can we do this on MySQL? For example: Where Customer Like "%" + :CustName + "%". CustName is the parameter where I'll specify the value on runtime.

Thanks.