From de9cbba690ae813be901dd0e2277a26cbd1f8d77 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Wed, 27 Aug 2003 13:36:22 +0000
Subject: [PATCH] Minor change to make user searches a bit better

Next time I'll put proper paging in
---
 lib/datalib.php | 8 ++------
 1 file changed, 2 insertions(+), 6 deletions(-)

diff --git a/lib/datalib.php b/lib/datalib.php
index a1ae05a36a..67a509cf03 100644
--- a/lib/datalib.php
+++ b/lib/datalib.php
@@ -1012,9 +1012,7 @@ function get_users($get=true, $search="", $confirmed=false, $exceptions="", $sor
 /// $sort is a sorting criteria to use
 
     if ($search) {
-        $search = " AND (firstname LIKE '%$search%'
-                     OR lastname LIKE '%$search%'
-                     OR email LIKE '%$search%') ";
+        $search = " AND (CONCAT(firstname,\" \",lastname) LIKE '%$search%' OR email LIKE '%$search%') ";
     }
 
     if ($confirmed) {
@@ -1054,9 +1052,7 @@ function get_users_listing($sort, $dir="ASC", $page=1, $recordsperpage=20, $sear
     }
 
     if ($search) {
-        $search = " AND (firstname LIKE '%$search%'
-                     OR lastname LIKE '%$search%'
-                     OR email LIKE '%$search%') ";
+        $search = " AND (CONCAT(firstname,\" \",lastname) LIKE '%$search%' OR email LIKE '%$search%') ";
     }
 
     return get_records_sql("SELECT id, username, email, firstname, lastname, city, country, lastaccess  
-- 
2.39.5