Search across multiple columns

sql

SELECT *
FROM customers
WHERE first_name LIKE '%john%'
   OR last_name LIKE '%john%'
   OR email LIKE '%john%';

Explanation

Simple LIKE search is easy to start with, though full-text search is better at scale.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Pagination, Deduplication, and Search Patterns

Paginate by a stable cursor instead of a large OFFSET.

Open In sheetsqlsame section

Keep one row per business key and remove duplicates logically.

Open In sheetsqlsame section

Inspect the execution plan for a SELECT statement.

Speed up frequent equality or range predicates.

Detect repeated values that should be unique.

Run a query and collect timing or actual row information where supported.