By default MySQL search statements are case insensitive: http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html
-MI --------------------------------------------------------------------------- Remember, smart coders answer ten questions for every question they ask. So be smart, be cool, and share your knowledge. BAKE ON! blog: http://www.MarianoIglesias.com.ar -----Mensaje original----- De: [email protected] [mailto:[EMAIL PROTECTED] En nombre de squidliberty Enviado el: Domingo, 25 de Febrero de 2007 02:02 p.m. Para: Cake PHP Asunto: Case insensitive findAll? I need to execute a complex findAll query that that is case insensitive. I have tried using lower() and ILIKE (note sure if this exists in MySQL) in my conditions, but neither seem to work for me. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
