Finding SQL Rows With Similar Values

Let me first clarify what I mean by similar values. Imagine the following Users table containing emails and names:

How would we go about retrieving all Gmail emails? Allow me to introduce you to LIKE. 🤗 This command enables you to perform some basic pattern matching.

SELECT * FROM Users WHERE Email LIKE '%gmail%';

Outputs:

After LIKE, simply enter the common value you'd like to find.

% serve as a catch-all symbol, meaning it will match any character. For instance, %gmail will only match with values that has any kind and any amount of characters preceding the word gmail, but none following it.