SQL Query very slow

[Larz60+]

Is the name the only way the two tables are related? There's no ids or anything?

Unfortunately yes, however new tables will have PlaceId code

Depending on how much control you have, rebuilding the table to use a fulltext search engine would make it work as expected, if you use the keyword 'match' instead of 'like'

This is a possibility, however once Id's have been added, this query will never have to be performed again.

Or, you can use pragma declarations to let sql know you don't care about case sensitivity, then it might decide to use the index:

probably a good idea

sqlite apparently doesn't let you alter tables that already exist, so you can't modify the collation of a preexisting table. But you can create a temporary table to hold the contents, drop the table, recreate it using the proper collation, then put the data back in:https://stackoverflow.com/a/47469890

sqlite is a temporary solution. I plan on converting all to PostGreSQL ASAP.
legacy prevents me from doing that until I put out some fires that I didn't start.

I will try your code suggestion, it looks like a good solution.

It's coming back to me slowly, it's been quite a while since I had to so any SQL other than simple stuff, But had many years experience with ORACLE, Sybase and Informix (20+ years ago)