From 82508bfcf378f63231e641bd4e3a46e9baca0952 Mon Sep 17 00:00:00 2001
From: Peter Thienel <thienel@data-quest.de>
Date: Thu, 5 Feb 2026 12:11:33 +0100
Subject: search for courses fixed, fixes #6227

---
 lib/extern/ExternPageCourses.php | 9 ++++-----
 1 file changed, 4 insertions(+), 5 deletions(-)

diff --git a/lib/extern/ExternPageCourses.php b/lib/extern/ExternPageCourses.php
index 1d29523..0658ebf 100644
--- a/lib/extern/ExternPageCourses.php
+++ b/lib/extern/ExternPageCourses.php
@@ -347,12 +347,11 @@ class ExternPageCourses extends ExternPage
      */
     private function getSearchSQL(array &$params): string
     {
-        if ($this->sword && mb_strlen($this->sword) > 2) {
-            $params[':sword'] = $this->sword;
+        if ($this->searchtext && mb_strlen($this->searchtext) > 2) {
+            $params[':searchtext'] = $this->searchtext;
             return "
-                    AND (`seminare`.`Name` LIKE '%:sword%'
-                        OR `seminare`.`VeranstaltungsNummer` LIKE '%:sword%'
-                        OR `auth_user_md5`.`Nachname`)";
+                    AND (`seminare`.`Name` LIKE CONCAT('%',:searchtext,'%')
+                        OR `seminare`.`VeranstaltungsNummer` LIKE CONCAT('%',:searchtext,'%'))";
         }
         return '';
     }
-- 
cgit v1.0