Welcome Guest, Not a member yet? Register   Sign In
Database Helper - Between clause
#1

[eluser]The Revel[/eluser]
I was wondering is there was some sort of between clause for active record, for instance:
Code:
$query = $this->db->from('table')
                  ->where('date')
                  ->between('2012-04-01','2012-05-01')
                  ->get();

This would produce
Code:
SELECT * FROM table WHERE date BETWEEN '2012-04-01' AND '2012-05-01'

I am surprised this does not exist as a clause, and if it does I am surprised its not in the user manual.


Messages In This Thread
Database Helper - Between clause - by El Forum - 05-10-2012, 07:07 PM
Database Helper - Between clause - by El Forum - 05-10-2012, 08:33 PM
Database Helper - Between clause - by El Forum - 05-10-2012, 08:38 PM
Database Helper - Between clause - by El Forum - 05-10-2012, 10:14 PM
Database Helper - Between clause - by El Forum - 05-11-2012, 03:20 AM



Theme © iAndrew 2016 - Forum software by © MyBB