php - 从 mysql select 中排除空数据

Question

在排除空数据时遇到问题，我只想提取具有 discord_id 数据的行。这是我的代码:

<?php
$con=mysqli_connect("localhost","site","password","table");

if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$result = mysqli_query($con,"SELECT * FROM core_members");

while($row = mysqli_fetch_array($result))
  {
  echo $row['name'] . " " . $row['discord_id']; 
  echo "<br />";
  }

mysqli_close($con);

?>

Answer 1

你必须使用 MySQL: IS NOT NULL如下所示:-

$result = mysqli_query($con,"SELECT * FROM `core_members` WHERE `discord_id` IS NOT NULL");