like wildcards when using query binding problem |
[eluser]dcallan[/eluser]
Does anyone know how I should write queries with like statements when I want to use query binding? The code snippet I have is below:: Code: $Query = "select itemCode, itemName from OITM where itemCode like %?% or itemName like %?%"; However it produces an error with the follwoing query: select itemCode, itemName from OITM where itemCode like %'lamp'% or itemName like %'lamp'% when valid SQL is something like select itemCode, itemName from OITM where itemCode like '%lamp%' or itemName like '%lamp%' Thanks in advance.
[eluser]Jaketoolson[/eluser]
You could use the Active Record Class. Code: $this->db->like('title', 'match'); |
Welcome Guest, Not a member yet? Register Sign In |