像使用php的mysql中的运算符

Question

I need to fetch the data from database using like operator.If I use static value i got the answer but using dynamically I can't fetch it.Any body know the answer please help.

$query = mysql_query("SELECT * FROM table WHERE the_number LIKE '2016-01-09%'");
function calendercheck($data)
{
    $query = $this->db->query("SELECT * FROM events WHERE start_date LIKE '$data%'");
    return($query->result());
}

Answer 1

You can use WHERE docdate BETWEEN '$from' AND '$to' for filter data in mysql.