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.