WHERE is not working.

Hi

i have the following code below that mysql WHERE FUNCTION Is NOT WORKING whine i use OR_LIKE. but whine i try to remove all OR_LIKE it well work perfect.

Code:

$this->db->select('users.*,query1.*,query_price.*,');
$this->db->from('query_price');
$this->db->join('query1','query1.Barcode = query_price.Barcode', 'left');
$this->db->join('users','query_price.username = users.username', 'left');
$this->db->order_by('query_price.price_id','desc');
    
$this->db->where('query_price.approve !=',''); // THIS IS NOT WORK //

$this->db->like('query1.description',$search_keyword);
$this->db->or_like('query_price.Barcode',$search_keyword);
$this->db->or_like('query_price.new_cost',$search_keyword);
$this->db->or_like('query_price.new_dp',$search_keyword);
$this->db->or_like('query_price.new_srp',$search_keyword);
$this->db->or_like('query_price.new_reg',$search_keyword);
$this->db->or_like('query_price.dis_a',$search_keyword);
$this->db->or_like('query_price.dis_b',$search_keyword);
$this->db->or_like('query_price.date',$search_keyword);
$this->db->or_like('query_price.prepare',$search_keyword);

i try different methods but im NOT luck, and im hoping that i get the answer here.

Thanks in advance..