SELECT查询中的关系（PHP）

Question

I have little problem with SQL query in PHP. I want to get from table post rows with category ex. 'art'. This table don't contain name of my category (only category_id). So, how to connect this in my query?

Tables:

post:

id, title, category_id

category:

id, name

I tried this way, but it not works.

SELECT * FROM post WHERE category_id = category.id AND category.name="art";

Anyone can help me? Thanks.

Answer 1

You are missing the JOIN

SELECT * FROM post 
INNER JOIN category 
WHERE category_id = category.id AND category.name="art";