From 3e062ff608a92c0c6161dfb20323b5e7953e8486 Mon Sep 17 00:00:00 2001 From: ben Date: Wed, 11 Feb 2009 11:11:33 +0000 Subject: Removing wildcard from the beginning of 'like' search for user/username git-svn-id: https://code.elgg.org/elgg/trunk@2716 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/lib/users.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'engine/lib') diff --git a/engine/lib/users.php b/engine/lib/users.php index ca68c0fed..f16f5c0f6 100644 --- a/engine/lib/users.php +++ b/engine/lib/users.php @@ -853,7 +853,7 @@ } $query .= "from {$CONFIG->dbprefix}entities e join {$CONFIG->dbprefix}users_entity u on e.guid=u.guid where "; // $query .= " match(u.name,u.username) against ('$criteria') "; - $query .= "(u.name like \"%{$criteria}%\" or u.username like \"%{$criteria}%\")"; + $query .= "(u.name like \"{$criteria}%\" or u.username like \"{$criteria}%\")"; $query .= " and $access"; if (!$count) { -- cgit v1.2.3