Search the Community
Showing results for tags 'Simple If statement in MySQL'.
-
Morning/Afternoon All, I'm trying to create a simple if statement in SQLThis has been casuing me so much trouble since yesterdayHere's what i'm trying to achieve. IF((SELECT COUNT(*) FROM computers WHERE name='PC-01' AND domain='mydomain.local')==1)SELECT ComputerID FROM computers WHERE name='PC-01' AND domain='mydomain.local'ELSE IF((SELECT COUNT(*) FROM computers WHERE name='PC-01' AND domain='mydomain')==1)SELECT ComputerID FROM computers WHERE name='PC-01' AND domain='mydomain'ELSE IF(SELECT COUNT(*) FROM computers WHERE name='PC-01')==1)SELECT ComputerID FROM computers WHERE name='PC-01' I have tried: IF((SELECT COUNT(*) FROM computers WHERE name='PC-01' AND domain='mydomain.local')==1)BEGINSELECT ComputerID FROM computers WHERE name='PC-01' AND domain='mydomain.local'ENDELSE IF((SELECT COUNT(*) FROM computers WHERE name='PC-01' AND domain='mydomain')==1)BEGINSELECT ComputerID FROM computers WHERE name='PC-01' AND domain='mydomain'ENDELSE IF(SELECT COUNT(*) FROM computers WHERE name='PC-01')==1)BEGINSELECT ComputerID FROM computers WHERE name='PC-01'END Along with other suggests which google returned. to no luck. How can a simple IF statement be so complicated? (Side Note: using phpmyadmin i cannot do print/echo/prompt commands is that normal?)
- 4 replies
-
- Simple If statement in MySQL
- if statement
-
(and 1 more)
Tagged with: