其中JSON数据

Question

I want done where date now with dates that there are in database table as JSON in offset 2 (like: 2011/10/30 = date now and Etc.), in my try output num rows is 0. how can done it?

My column in table:

$today = date("Y/m/d"); // This is 2011/10/30
$query = $this->db->query("SELECT * FROM table WHERE new_date LIKE $today");
echo $query->num_rows(); // This output is "0"

Answer 1

Try

$query = $this->db->query("SELECT * FROM table WHERE new_date LIKE '".$today."'");