Welcome Guest, Not a member yet? Register   Sign In
query builder like with wildcard in the middle
#1

Code:
SELECT * FROM table WHERE column LIKE 'some%thing'


3rd parameter
after = 'some%thing%'
before = '%some%thing'
both (or leave empty) = '%some%thing%'

but how with 'some%thing' ??

i just can use this:
Code:
SELECT * FROM table WHERE column LIKE '%" .$this->db->escape_like_str($search)."%' ESCAPE '!


can i use query builder to produce LIKE clause with wildcare in the middle?
Reply


Messages In This Thread
query builder like with wildcard in the middle - by plonknimbuzz - 12-20-2017, 01:24 PM



Theme © iAndrew 2016 - Forum software by © MyBB