php - 将 varchar 中的日期与 mysql 和 php 进行比较

Question

我试图比较名为“fecha_registro ”的列中的两个日期，该列是 varchar (100)，我试图将他与此日期代码进行比较:

<?php

$host = "localhost";
$user = "root";
$pass = "";
$db   = "gimnasio";

mysql_connect($host, $user, $pass);
mysql_select_db($db);

$from = "2010-02-06";
$to = "2015-11-08";

$consulta = mysql_query("SELECT id_cliente FROM clientes WHERE fecha_registro BETWEEN '$from' AND '$to'");
$cantidad = mysql_num_rows($consulta);

echo $cantidad;

?>

问题是，当多个记录满足该模式时，您永远找不到任何记录

“clients”表的结构是这样的:

记录如下:

请帮我解决这个问题？

Answer 1

试试这个

 SELECT id_cliente FROM clientes WHERE  
 DATE_FORMAT(STR_TO_DATE(fecha_registro, '%Y-%c-%e'), '%Y-%m-%d')
 BETWEEN '$from' AND '$to'