Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

Re: [ryel01] Select Statement

Jul 5, 2004, 11:55 AM
Alex
Administrator (9387 posts)
Jul 5, 2004, 11:55 AM
Views: 3394
Shortcut
Quote Reply
Re: [ryel01] Select Statement In reply to
Hi,

A bit better would be:

my ($total) = $DB->table('Users')->select(['COUNT(DISTINCT(Email))'], {ReceiveMail=>'Yes'})->fetchrow_array;

but you are getting into non-portable SQL here. I don't believe this works in mysql 3.23 (or maybe 3.22). This will be a bit better as the database server is not fetching all the rows, but rather it's doing the counting.

Cheers,

Alex

--
Gossamer Threads Inc.
Subject Author Views Date
Thread Select Statement ryel01 3479 Jul 2, 2004, 5:34 PM
Thread Re: [ryel01] Select Statement 		Andy 3405 Jul 3, 2004, 1:34 AM
Thread Re: [Andy] Select Statement 		ryel01 3393 Jul 3, 2004, 11:23 PM
Thread Re: [ryel01] Select Statement 		Andy 3387 Jul 4, 2004, 5:24 AM
Thread Re: [Andy] Select Statement 		ryel01 3380 Jul 4, 2004, 5:29 AM
Thread Re: [ryel01] Select Statement 		afinlr 3388 Jul 4, 2004, 7:52 AM
Thread Re: [afinlr] Select Statement 		ryel01 3382 Jul 4, 2004, 2:09 PM
Thread Re: [ryel01] Select Statement 		Alex 3394 Jul 5, 2004, 11:55 AM
Post Re: [Alex] Select Statement 		afinlr 3355 Jul 5, 2004, 3:40 PM