I have an MySQL Query that give me Empty Set.
SELECT IFNULL(TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)),0)
FROM radacct
WHERE UserName='Test'
ORDER BY acctstarttime
LIMIT 1:
I need something like this, but without IFNULL.
Amateur description? :
SELECT """IF Empty SET""""(TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)),0)
FROM radacct
WHERE UserName='Test'
ORDER BY acctstarttime
LIMIT 1:
Amateur description [smiley] :
SELECT """IF Empty SET""""(TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)),0)
FROM radacct
WHERE UserName='Test'
ORDER BY acctstarttime
LIMIT 1: