如何根据 IF 条件执行 Mysql SELECT 语句？

Question

我想将 2 个 mysql 调用合并为一个带有 if 条件的调用。这就是我目前拥有的：

IF
mysql_query("SELECT File FROM DB.ShoePics WHERE Cover='1' AND ShoeID='$ShoeID' LIMIT 1")
Else
mysql_query("SELECT File FROM DB.ShoePics WHERE Cover='0' AND ShoeID='$ShoeID' LIMIT 1")

我想它看起来会与此类似，但我知道它不正确：

mysql_query("SELECT File FROM DB.ShoePics WHERE IF(Cover='1')ELSE(Cover='0') AND ShoeID='$ShoeID' LIMIT 1")

有人可以告诉我怎么做吗？谢谢！

Answer 1

让你的查询像

SELECT File FROM DB.ShoePics WHERE (Cover='1' OR Cover='0') AND ShoeID='$ShoeID' LIMIT 1

Answer 2

SELECT File 
FROM DB.ShoePics 
WHERE  
    CASE WHEN CONDITION=1 THEN Cover='1' ELSE Cover='0' END
    AND ShoeID='$ShoeID' LIMIT 1"

Answer 3

mysql_query("从 DB.ShoePics 中选择文件，其中 (Cover='1' AND ShoeID='$ShoeID' LIMIT 1") OR (Cover='0' AND ShoeID='$ShoeID' LIMIT 1")