CodeIgniter Forums
Wildcard for WhereIn clause - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Wildcard for WhereIn clause (/showthread.php?tid=82572)



Wildcard for WhereIn clause - humbucker - 07-25-2022

Hello
I'm coding a filter search based on url parameters.
Users can select multiple values.
I'm using WhereIn clause, and it's working ok.
But when they don't select any value for some filters, these parameters array are null and create an error,
is there a wildcard to use for empty array so that my whole select query would still run correctly ?
Thank you