From 2d429b7dd1457241e691e8a1e499c343a358668d Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Sat, 26 Nov 2011 22:52:37 -0800 Subject: make tag search case insensitive --- getjson.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/getjson.php b/getjson.php index 14af09b..007ef7c 100644 --- a/getjson.php +++ b/getjson.php @@ -42,12 +42,12 @@ else $result = $DB->query("SELECT base_uri, filename FROM photos ". " left join photo_tags on photos.id=photo_tags.photo_id ". " left join tags on tags.id=photo_tags.tag_id ". - " where tags.name in ($tags) LIMIT $OFFSET, $N"); + " where tags.name COLLATE NOCASE in ($tags) LIMIT $OFFSET, $N"); $count = $DB->query("SELECT count(*) as total FROM photos ". " left join photo_tags on photos.id=photo_tags.photo_id ". " left join tags on tags.id=photo_tags.tag_id ". - " where tags.name in ($tags)"); + " where tags.name COLLATE NOCASE in ($tags)"); } else -- cgit v1.2.3-18-g5258