mysql php 语句

Question

我有这些陈述。

"SELECT * FROM PLACE.country WHERE Number='" .mysql_real_escape_string($num) ."'";<br>
"SELECT * FROM PLACE.country WHERE StreetNumber='" .mysql_real_escape_string($num) ."'";<br>
"SELECT * FROM PLACE.country WHERE PostNumber='" .mysql_real_escape_string($num) ."'";

我如何将这些加入到一个声明中？

谢谢

Answer 1

SQL AND & OR 语句。

下面是一个示例（SQL 语言）：

SELECT * FROM `some_table` WHERE `a`='1' AND `b`='2' AND `c`='3'

/neurotic

SELECT * FROM `some_table` WHERE `a`='1' OR `b`='2' OR `c`='3'

Answer 2

"
    SELECT *
    FROM PLACE.country
    WHERE Number='" .mysql_real_escape_string($num) ."'
       OR StreetNumber='" .mysql_real_escape_string($num) ."'
       OR PostNumber='" .mysql_real_escape_string($num) ."'
";

Answer 3

使用 OR MySQL 语句列出所有并发条件：

"SELECT * FROM PLACE.country WHERE Number='" .mysql_real_escape_string($num) ."' OR StreetNumber='" .mysql_real_escape_string($num ) ."' OR PostNumber='" .mysql_real_escape_string($num) ."'";