From 227eb02f9ac100e1314cab4c4751e450bbe14d21 Mon Sep 17 00:00:00 2001 From: Chocobozzz Date: Fri, 27 Dec 2019 08:49:31 +0100 Subject: Case insensitive tags search --- server/models/video/video.ts | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'server/models') diff --git a/server/models/video/video.ts b/server/models/video/video.ts index 990c66907..164122ee2 100644 --- a/server/models/video/video.ts +++ b/server/models/video/video.ts @@ -1371,7 +1371,7 @@ export class VideoModel extends Model { 'UNION ALL ' + 'SELECT "video"."id" FROM "video" LEFT JOIN "videoTag" ON "videoTag"."videoId" = "video"."id" ' + 'INNER JOIN "tag" ON "tag"."id" = "videoTag"."tagId" ' + - 'WHERE "tag"."name" = ' + escapedSearch + + 'WHERE lower("tag"."name") = lower(' + escapedSearch + ')' + ')' ) } -- cgit v1.2.3