SEOClerks

MySQL SELECT Query (Emtpy Set).

MySQL SELECT Query (Emtpy Set).



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:


Requirements

Amateur description [smiley] :
SELECT """IF Empty SET""""(TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)),0)
FROM radacct
WHERE UserName='Test'
ORDER BY acctstarttime
LIMIT 1:


Skills Required

Mysql

Bids

No bids made yet - be the first!

Bid On Listing

Bid On Listing Created 10 years ago in Programming

Other jobs by disem