I have logic that is based on If/Else statement. This should be applied in SQL where clause filter. Here is example on how that should look like:
if (type = 'DEV') { // If type is DEV then status should be Y
status = 'Y'
}else{ // If not do not apply filter
1=1
}
I have tried this in SQL:
WHERE id IN (89,56,87)
AND (
(type = 'TRNG' AND status = 'Y')
OR
(1=1)
)
I'm wondering if there is a way to achieve what I have in if/else statement?
Aucun commentaire:
Enregistrer un commentaire