mysql选择distinct,但仅当第二列全部为1时才选择distinct?

我只想让这个不要退货。我该怎么做?

mysql> select distinct (search_num), complete from Table where complete = '1';
+------------+----------+
| search_num | complete |
+------------+----------+
|       1825 |        1 |
+------------+----------+

因为实际上有一行(或多行)仍然是0,如图所示:

mysql> select distinct (search_num), complete from Table;
+------------+----------+
| search_num | complete |
+------------+----------+
|       1825 |        1 |
|       1825 |        0 |
+------------+----------+

我该怎么做?