title: Uncaught PDOException: SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s)
body: <p>I got error like.<br>
  <strong>Uncaught PDOException: SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s)</strong></p>
  
  <pre><code>if ($_POST['submit'] ?? '' == "Log In") {
  
      $query = "SELECT * FROM member WHERE (email, password) LIKE (:email, :password)";
  
      $stmt = $link -&gt; prepare($query);
      $stmt -&gt; bindValue(':email', $_POST['loginemail'], PDO::PARAM_STR);
      $stmt -&gt; bindValue(':password', md5(md5($_POST['loginemail']).$_POST['loginpassword']), PDO::PARAM_STR);
      $stmt -&gt; execute();
      $rows = $stmt -&gt; fetchAll();
  
  }
  </code></pre>
  
  <p>but There's no error in this statement.</p>
  
  <pre><code>$sql = "SELECT ko_name FROM dogBREEDS WHERE dogBREEDS.ko_name LIKE (:keyword) ORDER BY id ASC LIMIT 0, 10";
  $query = $pdo-&gt;prepare($sql);
  $query-&gt;bindParam(':keyword', $keyword, PDO::PARAM_STR);
  $query-&gt;execute();
  $list = $query-&gt;fetchAll();
  </code></pre>
  
  <p>How can I solve this? and What's the difference??</p>