+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30)
+--- Thread: CodeIgniter 4 - How to use CAST (/showthread.php?tid=83772)
CodeIgniter 4 - How to use CAST - Luís Andrade - 10-10-2022
Hi, guys!
Simple example to use CAST in CI4 when we need order strings
Considering Query builder.
... ->orderBy('CAST(table_name AS SIGNED),'ASC')
use SIGNED/UNSIGNED, ASC/DESC according to your needs.