From 85213d3bee5c4373f12378c3fa910f0e93e6d678 Mon Sep 17 00:00:00 2001
From: Angie Byron <webchick@24967.no-reply.drupal.org>
Date: Wed, 13 Jan 2010 06:44:31 +0000
Subject: #279851 by catch, et al: Replace LOWER() with db_select() and LIKE()
 where possible.

---
 modules/comment/comment.module | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'modules/comment/comment.module')

diff --git a/modules/comment/comment.module b/modules/comment/comment.module
index 0b3fc2d8c..691c1421b 100644
--- a/modules/comment/comment.module
+++ b/modules/comment/comment.module
@@ -1990,7 +1990,7 @@ function comment_form_validate($form, &$form_state) {
         $query = db_select('users', 'u');
         $query->addField('u', 'uid', 'uid');
         $taken = $query
-          ->where('LOWER(name) = :name', array(':name' => $form_state['values']['name']))
+          ->condition('name', db_like($form_state['values']['name']), 'LIKE')
           ->countQuery()
           ->execute()
           ->fetchField();
-- 
cgit v1.2.3