🐘 Matching a sub-string in PostgreSQL

This is embarrassing how many times I have had to look this up. Writing it down this time, so atleast I know for sure where I can find the info.

Let's say you have a table named people_info with one of the columns called email:

Now we only want rows where email contains the sub-string varun.

select email
from people_info
where email like '%varun%';

This now gives us: