sql between 2 dates

[eluser]Unknown[/eluser]
Hi, I'm working on "select * from tables where mydate between date_start and date_stop" but I don't know the command in codeigniter "$this->db->where('mydate'..."

[eluser]the_yk[/eluser]
try this...

Code:

$this->db->where("mydate between date_start and date_stop");

[eluser]Unknown[/eluser]
That's the answer. Thanks.