This article describes the basic syntax for using the LIKE operator, as well as illustrated examples of how to apply it in queries using one of the most popular MySQL IDEs on the market, dbForge Studio for MySQL - https://blog.devart.com/mysql-like-tutorial.html