如何在CodeIgniter中的db-> get_where（）中使用“大于”和“小于”？ [重复]

Question

This question already has an answer here:

• Codeigniter Active record: greater than statement 4 answers

I'm having a problem about my project. Because my logic wants something like

$this->db->get_where('products', array('prod_price' > 100 ));

So. I wan't to know if there is a solution for this.

</div>

Answer 1

The custom operator should be part of the column's string:

$this->db->get_where('products', array('prod_price >', 100 ));
# Here --------------------------------------------^