hey,

I am using sesql.com to query Goggle with SQL and I am having trouble
with my query. The following works:

SELECT gog.*
FROM google gog
WHERE searchterm = 'jokes'
and searchterm = 'cats'
and searchterm != 'dogs'
and website != 'wikipedia.com'

but when I try to retrict my query with

SELECT gog.*
FROM google gog
WHERE searchterm = 'jokes'
and searchterm = 'cats'
and searchterm != 'dogs'
and website != 'wikipedia.com'
and rownum < 5

it still gives me everything???

help!!

yoitout (AT) gmail (DOT) com wrote:

Why does it get you anything? searchterm can not be both 'jokes'
and 'cats', so the where should always compute to false.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.