php mysql复杂查询_php – 复杂的MySQL查询

你可以这样做：

SELECT

t1.post_id,

t1.meta_value AS name,

t2.meta_value AS season,

t3.meta_value AS episode

FROM

(

SELECT *

FROM the_table

WHERE meta_key = 'name'

) t1

INNER JOIN

(

SELECT *

FROM the_table

WHERE meta_key = 'season'

) t2 ON t1.post_id = t2.post_id

INNER JOIN

(

SELECT *

FROM the_table

WHERE meta_key = 'episode'

) t3 ON t1.post_id = t3.post_id

这会给你结果：

| post_id | name | season | episode |

-------------------------------------------

| 1 | Smallville | 1 | 1 |

| 2 | Smallville | 1 | 2 |

在这种形式下,任何操作都更容易.

你需要的是添加：

WHERE name = 'Smallville'

ORDER BY season, episode