Welcome Guest, Not a member yet? Register   Sign In
My query returns empty results with big tables. Any advice?
#2

PHP Code:
$this->db->like('email'$input_string); 

First thing to try - don't use like, use where. The email address has to be exact so like is unnecessary.
Second - do you have indexes on the fields you are searching?
Reply


Messages In This Thread
RE: My query returns empty results with big tables. Any advice? - by cartalot - 09-14-2016, 03:08 PM



Theme © iAndrew 2016 - Forum software by © MyBB