Braindead

Hi guys,

maybe I am too stupid, but I can not see a solution for this. Have been
cracking up my brain for the last hours, so I finally dare to ask.

I have a database table with some columns


text1 | text2 | text3 | text4
----------------------------------------------


Now, for some stats thingy, I am trying to get the COUNT of distinct entries
So, i would like to get the count of entries where text2 is foo OR text3 is
foo

I have 20.863 entries at the moment, and it takes quite a lot of time
reading through that stuff.
I have tried

SELECT COUNT(*) as mycount FROM mytable WHERE text2 = 'foo' and text3 =
'foo'

but I neither get an error nor any output. It just loads and loads without
any output...

I am out of ideas :o( Help, anybody? :o))

Chris


.

Relevant Pages

  • Re: [PHP] Braindead
    ... I have a database table with some columns ... Now, for some stats thingy, I am trying to get the COUNT of distinct entries ... i would like to get the count of entries where text2 is foo OR text3 is ... It just loads and loads without ...
    (php.general)
  • Re: [PHP] Braindead
    ... -:- of distinct entries ... I tried it in a PHP script. ... said you wanted results "where text2 is foo OR text3 is ... Is there a way to order the output by the apcount value? ...
    (php.general)
  • Re: Style question - defining immutable class data members
    ... causing a "surprising decoupling"   ... entries in 'foo's dictionary are those attributes which are particular ... to 'foo'. ... much of a chance of making it in to Python. ...
    (comp.lang.python)
  • Re: Reprise: in out parameters for functions
    ... > task type Foo is ... ... entries can only be declared inside a task ... entries (and interface procedure calls can be used in select statements), ...
    (comp.lang.ada)
  • XP slow to start up
    ... entries. ... Use msconfing and services.msc ... >loads fine, through the standard xp screen and the ...
    (microsoft.public.windowsxp.general)