PostgreSQL LIKE
Summary: in this tutorial, you will learn how to use the PostgreSQL LIKE and ILIKE operator to query data by using pattern matching technique. Suppose the store manager asks you find a customer that he does not remember the name exactly. He just remembers that customer's first name begins with something like Jen.
https://www.postgresqltutorial.com/postgresql-like/