title: mySQL SELECT FROM table WHERE ... AND ... AND ... AND
body: <p>I have a table "articles" with columns and data:</p>
  
  <pre><code>article_id     title               body
  1            This is the title   This is the body text
  2            Another title       Another body text
  </code></pre>
  
  <p>Another table "category" with columns and data:</p>
  
  <pre><code>category_id    category
  1              localnews
  2              visible
  3              first10
  </code></pre>
  
  <p>And a table "categories" with columns and data:</p>
  
  <pre><code>categories_id   article_id  category_id
  1               1           1
  2               1           2
  3               1           3
  4               2           1
  5               2           3
  </code></pre>
  
  <p>I want to SELECT the row(s) WHERE categories.category_id = 1 AND =2 AND =3</p>
  
  <p>I'm using:</p>
  
  <pre><code>SELECT articles.article_id, articles.title, articles.body, 
  categories.article_id, categories.category_id 
  FROM articles, categories 
  WHERE articles.article_id = categories.article_id 
  AND categories.article_id = 1 
  AND categories.article_id = 2 
  AND categories.article_id = 3 
  </code></pre>
  
  <p>but it doesn't work. Obviously mySQL needs another syntax. 
  Can someone help?
  Thanks</p>