mysql - 从表中选择，其中 col1 AND col1

Question

我正在尝试运行此 MySQL 查询:

SELECT SUM(arg2) as talktime FROM voipnow.ast_queue_log 
        WHERE queuename = '0536*401' 
        AND DATE(time) = '2014-03-17' 
        AND (event = 'COMPLETECALLER' AND event = 'COMPLETEAGENT') 
        ORDER BY time DESC

但没有返回结果，我也尝试过:

SELECT SUM(arg2) as talktime FROM voipnow.ast_queue_log 
        WHERE queuename = '0536*401' 
        AND DATE(time) = '2014-03-17' 
        AND event = 'COMPLETECALLER' AND event = 'COMPLETEAGENT')
        ORDER BY time DESC

但还是没有结果

Answer 1

我想知道一列如何同时具有两个不同的字符串，也许您打算使用 OR而不是AND拥有具有 COMPLETECALLER 的所有记录和COMPLETEAGENT

SELECT SUM(arg2) as talktime FROM voipnow.ast_queue_log 
    WHERE queuename = '0536*401' 
    AND DATE(time) = '2014-03-17' 
    AND (event = 'COMPLETECALLER' OR event = 'COMPLETEAGENT')
    ORDER BY time DESC