{"action":"opened","issue":{"url":"https://api.github.com/repos/Piwigo/Piwigo/issues/422","repository_url":"https://api.github.com/repos/Piwigo/Piwigo","labels_url":"https://api.github.com/repos/Piwigo/Piwigo/issues/422/labels{/name}","comments_url":"https://api.github.com/repos/Piwigo/Piwigo/issues/422/comments","events_url":"https://api.github.com/repos/Piwigo/Piwigo/issues/422/events","html_url":"https://github.com/Piwigo/Piwigo/issues/422","id":135358595,"number":422,"title":"[quicksearch] no exact match on file","user":{"login":"plegall","id":9326959,"avatar_url":"https://avatars.githubusercontent.com/u/9326959?v=3","gravatar_id":"","url":"https://api.github.com/users/plegall","html_url":"https://github.com/plegall","followers_url":"https://api.github.com/users/plegall/followers","following_url":"https://api.github.com/users/plegall/following{/other_user}","gists_url":"https://api.github.com/users/plegall/gists{/gist_id}","starred_url":"https://api.github.com/users/plegall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/plegall/subscriptions","organizations_url":"https://api.github.com/users/plegall/orgs","repos_url":"https://api.github.com/users/plegall/repos","events_url":"https://api.github.com/users/plegall/events{/privacy}","received_events_url":"https://api.github.com/users/plegall/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-02-22T09:12:12Z","updated_at":"2016-02-22T09:12:12Z","closed_at":null,"body":"I wonder why we can't perform the same REGEXP pattern on file (compared to name/comment):\r\n\r\n```\r\nSELECT\r\n    id\r\n  from images i\r\n  WHERE (CONVERT(file, CHAR) LIKE '%eau%' OR name REGEXP '[[:<:]]eau[[:>:]]')\r\n;\r\n```\r\n\r\nHere we perform an exact match on name (perfect) but not on file :-/ If the user has filenames which describe the photo, it becomes impossible to perform an exact match."}}