Re: Pass Complex Parameters | Your Suggestion Please

[Jassim Rahma]

Sorry Barry maybe I was not able to explain it

What I want is to pass all values from my .NET app

and inside MySQL, I want to check like this

SELECT [my rows]
FROM [table]
JOIN [tables]
WHERE
[IF nationality is set the add it to WHERE otherwise ignore]
AND [IF gender is set the add it to WHERE otherwise ignore]
AND [IF country is set the add it to WHERE otherwise ignore]