On Wed, Jan 8, 2020 at 9:33 AM BeeRich33 <beer...@gmail.com> wrote:
>
>> My apologies for correcting you yet again, hence the questions here in
> the group meant for such questions:
>
> DBS[:searches_t].
> where{(exclude(search_phrase: nil))}.
> select(:search_phrase, :result_count)
>
>
>
Please go here
http://sequel.jeremyevans.net/rdoc/files/doc/dataset_filtering_rdoc.html#label-Negating+conditions
And look at the first example - you are combining concepts.
You want
DBS[:searches_t].
exclude(search_phrase: nil).
select(:search_phrase, :result_count)
That should pop out an IS NOT NULL for you.
I believe you would be fully looking for
DBS[:searches_t].
exclude(search_phrase: nil).
exclude(client_ip: '192.168.1.4').
select(:search_phrase, :result_count)
John W Higgins
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/CAPhAwGzr4MpMpGp4vDva97OUUfUH7UwaORgUtVon10fAYSMiug%40mail.gmail.com.
