Welcome Guest, Not a member yet? Register   Sign In
Embedding wildcard '%' into a query string
#1

[eluser]Unknown[/eluser]
I am doing a search query

Code:
// Prepare query string
//$searchstr = preg_replace('/\s{1,}/', '%', $searchstr);
  
$query = $this->db->select()
->from('employee')
->like("CONCAT(fname,' ',lname)", $searchstr)
->or_like('phone', $searchstr)
->order_by('lname','fname')
->get();

But when I uncomment the preg_replace line, the '%' get escaped in the call. I have tried %% also to no avail.

Any suggestions?


Messages In This Thread
Embedding wildcard '%' into a query string - by El Forum - 08-20-2012, 08:27 AM
Embedding wildcard '%' into a query string - by El Forum - 08-20-2012, 09:18 AM
Embedding wildcard '%' into a query string - by El Forum - 08-20-2012, 01:06 PM



Theme © iAndrew 2016 - Forum software by © MyBB