What's wrong with this SQL LIKE forcing a full scan?

What's wrong with this SQL LIKE forcing a full scan on a search. The SQL code uses LIKE with a leading wildcard. In MySQL that cannot use an index. In SQL one search scans millions of rows.

#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqllike #sqlwildcard #sqlindex...

https://www.youtube.com/watch?v=hjUaVDpUbHo

Whats wrong with this SQL LIKE forcing a full scan? #sqldataintegrity

YouTube