Further removal of instance of using LOWER() rather than relying on mysql non-case...
authoreileen <emcnaughton@wikimedia.org>
Thu, 2 Aug 2018 02:02:06 +0000 (14:02 +1200)
committereileen <emcnaughton@wikimedia.org>
Fri, 3 Aug 2018 08:46:49 +0000 (20:46 +1200)
commitb7aa36b615d4b1b25f7470d587dae9dead168f4b
treec26f3b9ebc9d85754a38b8d19f324d58c0a05bb3
parent0786231a107ed46bd66da194cdc627096d298097
Further removal of instance of using LOWER() rather than relying on mysql non-case-sensitivity.

Note I could not find any way to call this so I added deprecation notices

Per #12494 the use of LOWER

hurts performance
fails to return results on some char sets
messes with REGEX
This is part of a continued (we removed from contribution search fields last year)
staggered approach to removing this old mechanism
CRM/Contact/BAO/Query.php