summaryrefslogtreecommitdiffstats
path: root/sql/client_get_by_name_or_uid.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/client_get_by_name_or_uid.sql')
-rw-r--r--sql/client_get_by_name_or_uid.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/client_get_by_name_or_uid.sql b/sql/client_get_by_name_or_uid.sql
new file mode 100644
index 0000000..5d361e4
--- /dev/null
+++ b/sql/client_get_by_name_or_uid.sql
@@ -0,0 +1,3 @@
+select * from clients where clients.server_id = :server_id: and
+(client_unique_id like(:client_unique_id:) or
+client_nickname like(:client_nickname:)) limit 50 \ No newline at end of file