User talk:2601:600:9A7F:FD10:FCE0:8368:E878:5BA1

Characterizing LIKE as sargable may be an oversimplification
My understanding is that only some usage of LIKE are sargable. For example, if the pattern argument of LIKE starts with a wildcard, the DBMS won't be able to use an index. Source: https://use-the-index-luke.com/sql/where-clause/searching-for-ranges/like-performance-tuning.