Ergebnis der Suchanfrage

• Forum: Datenbanken

  Re: MySQL - Group by und Count

   
    by stifflersmom, 25. Feb 2008
  Vielleicht als ganz simples join:
  
  SELECT COUNT(a.article_id) as 'count'
  FROM articles a, articles_data ad
  Where ad.article_id = a.article_id
  AND ad.show_flag = 0
  AND ad.active = 1
  AND (a.text LIKE '%blubb%'
  OR a.title LIKE '%blubb%')