U MSSQL bazi imam ovakav upit sa opcionim parametrima koji savrseno radi:
SELECT *
FROM Orders
WHERE (CustomerID = @CustomerID OR @CustomerID IS NULL)
AND (EmployeeID = @EmployeeID OR @EmployeeID IS NULL)
AND NOT (@CustomerID IS NULL AND @EmployeeID IS NULL)
Sada treba to isto da uradim za MySQL bazu, ali ne znam kako, probao sam nekako ovako ali ne ide;
SELECT *
FROM Orders
WHERE (CustomerID = ? OR ? IS NULL)
AND (EmployeeID = ? OR ? IS NULL)
AND NOT (? IS NULL AND ? IS NULL)
Da li postoji nacin da se u MySql-u da neki naziv parametra, ovako kad imam 10 znakova pitanja ne znam sta je sta?