CodeIgniter Forums
SQL function in WHERE clause - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forum-21.html)
+--- Thread: SQL function in WHERE clause (/thread-33607.html)



SQL function in WHERE clause - El Forum - 09-01-2010

[eluser]Unknown[/eluser]
Can someone explain me the idea behind this not working

Code:
$this->db->where('MD5(column)', $value);

But instead

Code:
$this->db->where('MD5(column) = ', $value);



SQL function in WHERE clause - El Forum - 09-02-2010

[eluser]Clooner[/eluser]
Read the manual, especially the $this->db->where(); section. It describes exactly what you are asking!