Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Group By problem

forums › forums › Group By problem

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • March 24, 2003 at 2:22 pm #7774
      nero
      Member

      Hi,

      I have a table with email addresses and when i try to execute the next query

      SELECT count(lcase(email)) as cnt,lcase(email) FROM `np_bieter` GROUP BY email having cnt>1

      I get wrong results, there are many without email, some with 2 and some with 3 but when I execute the query

      in phpAdmin I get also several with 4 as count what is correct.

      MySQLyog can't find these or I make a mistake but don't know where.

      I tried it with ucase , lcase and whitout case but the result is always the same.

      I have tried it with where but no change.

      Any idee???

      For the rest the program looks o.k. (version 3.02 at the moment)

      p.s. MySQL Control Center 0.8.7-alpha has the same problem.

    • March 25, 2003 at 6:05 pm #13955
      nero
      Member

      Problem is solved

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.