合并两个表之前进行查询？ [英] merge two tables before make my query?

问题描述

我正在寻找一种方式来查询2个表：

I'm looking a way to make a query with 2 tables:

posts:
+----+-------------------- +
| ID | post_date           |
+----+---------------------+
| 1  | 2011-11-15 08:42:50 |
+----+---------------------+

meta:
+--------------------+------------+
| post_id | meta_key | meta_value |
+---------+----------+------------+
|    1    |    ip    |192.168.1.10| 
+---------+----------+------------+

所以，我需要查询给定的IP和返回ID，但日期必须至少为10分钟。

So, I need to make a query wich look for given IP and return ID but date of post must be at least 10 minutes old.

这是一个不好的例子：

SELECT ID 
FROM posts
WHERE ip = '192.168.0.1'
   AND post_date = '2011-11-15 08:32:50'

推荐答案

SELECT p.ID FROM posts p, meta m 
  WHERE m.post_id=p.ID 
    AND m.meta_value='192.168.0.1' 
    AND p.post_date < (NOW() - INTERVAL 10 MINUTE);

这篇关于合并两个表之前进行查询？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！