Hi, Im working with CI and oracle right now but i have difficulties if i use LIKE method.
My code like this :
Code:
$this->db->select('COUNT(*) AS FOUND');
$this->db->where($where);
$row = $this->db->get('"ci_r_user_log"')->row();
And the result is zero for FOUND
I try to look the query and the result like :
Code:
SELECT COUNT(*) AS FOUND FROM "ci_r_user_log" WHERE "ul_datetime_login" LIKE '23-09-2019%'
I try run the query with SQL Developer and get 4 data found. I checked and it's correct.
So why the query that run with CI is not working? But the query is good
Im sorry if my english is bad.