mysql - SQL 中的 Long Boolean Where

Question

关闭。我在其他地方犯了一个与 bool 值无关的错误。

我在这个 SQL 中做错了什么:

WHERE (country = 'HK') OR (country = 'TW') OR (country = 'AX')

输出中缺少 AX 的结果。

我对这个 bool 表达式做错了什么？

注1。 ' 在 AX 的末尾是我的错字。我在上面更正了。

完整代码在这里

$myresult = mysqli_query($GLOBALS['DBlink'],
    "SELECT $getcolumn 
     FROM levermann 
     WHERE 
        ( $sqlwhere2 ) AND 
        levermann.`WEEK` = 
            (SELECT `WEEK`, COUNT(*) AS cc 
            FROM levermann 
            WHERE ( $sqlwhere2 ) 
            GROUP BY `WEEK` 
            HAVING cc > 4 
            ORDER BY `WEEK` DESC 
            LIMIT 1 )
        AND $lswitch AND $marketcap 
    ORDER BY LScore2 DESC, MarketCAPUSD DESC, Stock_Short ASC 
    LIMIT 10;");

if  ($region == 'ASIA') {
    $sqlwhere2 = "
        ( country = 'HK' ) OR 
        ( country = 'TW' ) OR 
        ( country = 'AX' ) OR 
        ( country = 'KS' ) OR 
        ( country = 'SS' )";
    $region='Asia';
}

if  ($region == 'Global') {
    $sqlwhere2 = " country  like '%'"; 
    $region='Global';
}

if  ($region == 'US') {
    $sqlwhere2 = " country  = 'US'"; 
    $region='US';
}

Answer 1

末尾有一个特殊字符包围'AX'

另外，为什么不直接使用 in() 呢？

WHERE country in ('HK','TW','AX')