is this for an sqlite database? i wonder if LIKE matching can use indexes for matching prefixes...
hmm, there is a documented optimization for LIKE: im not sure i understand what it's saying, but presumably if the schema looked like: ```sql CREATE TABLE mytable ( ..., date TEXT ); CREATE INDEX ix_mytable_date ON mytable (date);``` then sqlite could perform an optimized range scan for certain patterns where only a prefix is needed to match, for example to list all rows from a particular day: ```sql SELECT * FROM table WHERE date LIKE '[2024.05.10%';```