I got a bucket which contain a scientific_name field (?) that may or may not contain uppercase (depending on the document)
Is there a way I can SELECT * FROM bucket WHERE scientific_name LIKE = ‘%myquery%’ and return a string like “MyQuery”? I have 450,000 documents and uppercase characters may vary but it would be important that they stayed that way.
If not I guess I’ll run a script to convert everything to lowercase and find a way to store where the uppercase characters are located.