php - ""哪里不为空

Question

我正在尝试使用 CI 编写语句，但在编写 WHERE is not = ""

时遇到问题

能给我一个到目前为止的例子

$empty = array('');
$this->db->where_not_in("$this->_table['shop_shipping_rules']}.shop_shipping_rule_name", $empty);

Answer 1

使用简单的 where() 尝试一下

$this->db->where("$this->_table['shop_shipping_rules']}.shop_shipping_rule_name !='' OR 
$this->_table['shop_shipping_rules']}.shop_shipping_rule_name IS NOT NULL
");

编辑

$this->db->select('*');
$this->db->from('mytable');
 $this->db->where("shop_shipping_rule_name IS NOT NULL AND shop_shipping_rule_name !=''")
$query = $this->db->get();

或者

$this->db->select('*');
$this->db->from('mytable');
 $this->db->where(" TRIM(shop_shipping_rule_name) IS NOT NULL AND TRIM(shop_shipping_rule_name) !=''")
$query = $this->db->get();

Active Record Class

Mysql TRIM()