在mysql中“喜欢”

Question

I have written a simple mysql search form that searches between two dates. This query working perfect:

$sql = "SELECT * FROM table WHERE  dateStarted like '%$checkin%' 
AND dateEnded like '%$checkout%'";

But with

$sql2 = "SELECT * FROM table WHERE  dateStarted = $checkin 
AND dateEnded = $checkout";

There is no any result? What is difference between two sql?

Edit:

$checkin and $checkout are date (16-07-2010) 

Thanks in advance

Answer 1

$checkin and $checkout are date (16-07-2010)

Try putting quotes in your query:

$sql2 = "SELECT * FROM table WHERE  dateStarted = '$checkin'
         AND dateEnded = '$checkout'";