query builder like with wildcard in the middle |
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? |
Messages In This Thread |
query builder like with wildcard in the middle - by plonknimbuzz - 12-20-2017, 01:24 PM
RE: query builder like with wildcard in the middle - by XtreemDeveloper - 12-23-2017, 10:24 AM
RE: query builder like with wildcard in the middle - by Wouter60 - 12-23-2017, 11:56 AM
RE: query builder like with wildcard in the middle - by mdr1384 - 06-13-2019, 05:43 AM
RE: query builder like with wildcard in the middle - by php_rocs - 06-13-2019, 08:45 AM
|