=
new SQLSearch(
"SELECT auth_user_md5.user_id, {$GLOBALS['_fullname_sql']['full_rev']} as fullname, username, perms "
. "FROM auth_user_md5 "
. "LEFT JOIN user_info ON (auth_user_md5.user_id = user_info.user_id) "
. "WHERE "
. "username LIKE :input OR Vorname LIKE :input "
. "OR CONCAT(Vorname,' ',Nachname) LIKE :input "
. "OR CONCAT(Nachname,' ',Vorname) LIKE :input "
. "OR Nachname LIKE :input OR {$GLOBALS['_fullname_sql']['full_rev']} LIKE :input "
. " ORDER BY fullname ASC",
_("Nutzer suchen"), "user_id")
Definition: SQLSearch.class.php:38