using System;

using System.Text.RegularExpressions;

using System.Linq;

public class Program

{

    public static void Main()

    {

        // REPLACING IS NULL AND IS NOT NULL CHECK TO ISNULL FUNCTION. FIX FOR AVOIDING SPACE ISSUE FROM DATA..

        string message="SELECT P.FLABELNUMBER, P.FREFERENCENUMBER FROM LDB1_PALLETINFO_2 IS IS NOT WHERE  P.FCURRENTBIN   IS   NULL  AND S.FSTAUTUSID IS NOT NULL";

        //REMOVING MULTIPLE SPACE TO GET PROPER COMMAND

        message= Regex.Replace(message, @"(\s)\s+", "$1");

        var messageList= message.Split(' ').ToList();

        int findindex=-1;

        var message2=message;

        var findCMD=string.Empty;

        var replaceCMD=string.Empty;

        if(messageList.Contains("IS")){

        for(int i=0;i<messageList.Count;i++){

            if(messageList[i] == "IS")

            {

                if(messageList.Count>= i+1 || messageList.Count >= i+2){

                    if(messageList[i+1] =="NULL"){

                        findindex =i-1;

                    findCMD=messageList[findindex]+" "+messageList[i]+" "+messageList[i+1];

                        replaceCMD = "IFNULL("+messageList[findindex]+",'') = ''";

                        i++;

                    }

                    else if(messageList.Count >= i+2){

                        if(messageList[i+1] =="NOT" && messageList[i+2] == "NULL"){

                        findindex =i-1;                         

                        findCMD=messageList[findindex]+" "+messageList[i]+" "+messageList[i+1]+" "+messageList[i+2];

                        replaceCMD = "IFNULL("+messageList[findindex]+",'') <> ''";

                            i+=2;

                        }

                    }       

                }

                if(findindex>-1)

                    message2= message2.Replace(findCMD,replaceCMD);             

            }

            else {

                findCMD=string.Empty;

                replaceCMD=string.Empty;

                findindex=-1;

            }

        }

        }

        Console.WriteLine("Oracle query: "+ message);

        Console.WriteLine( Environment.NewLine +"MYSQL query: "+ message2);

    }

}