+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Feature Requests (https://forum.codeigniter.com/forumdisplay.php?fid=29)
+--- Thread: Builder LIKE none option (/showthread.php?tid=90965)
Builder LIKE none option - mark.unwin - 05-29-2024
I would like to be able to use the like and not like builder functions without having to have the % wildcard placed for me.
This is for taking user input, so we don't know in advance what they might be.
For instance, $builder->like('2%23', 'none') would produce very different results to $builder->like('2', 'both') ['both' because it's the default is all].
No, using 'after' in the above case will not suffice because we don't know where the % may be required.
We already have both (the default), before and after. Can we add one more option of none?