summaryrefslogtreecommitdiffstats
path: root/sql/client_get_by_name_or_uid.sql
diff options
context:
space:
mode:
authorAlexander Sulfrian <alexander@sulfrian.net>2011-12-07 19:06:52 +0100
committerAlexander Sulfrian <alexander@sulfrian.net>2011-12-07 19:06:52 +0100
commit39081f84a402aebb52d98a43e4675c90135cea9b (patch)
tree9c188a70367774c721b745818b74d059f9ce119c /sql/client_get_by_name_or_uid.sql
parent2397764dd0e5efa2b613fd22f6bf9c183d07160b (diff)
downloadts3db_postgres-39081f84a402aebb52d98a43e4675c90135cea9b.tar.gz
ts3db_postgres-39081f84a402aebb52d98a43e4675c90135cea9b.tar.xz
ts3db_postgres-39081f84a402aebb52d98a43e4675c90135cea9b.zip
added sql files
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