如何执行基于IF条件的Mysql SELECT语句？

Question

我想将两个mysql调用组合成一个with和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选择文件WHERE (Cover='1‘AND ShoeID='$ShoeID’LIMIT 1") OR (Cover='0‘AND ShoeID='$ShoeID’LIMIT 1")