Tutorials

Web Development

Bootstrap CSS HTML JavaScript jQuery Node.js PHP React TypeScript

Programming

C C#C++Go Java Python Rust

Data and Databases

NumPy Pandas SQL

Tools

Projects

Project: A Tiny Shell in C Project: Bank Account System Project: Library Management System Project: Portfolio Page Project: Quiz App in React Project: Sales Data Analysis Project: Server Log Analyser Project: To-Do REST API Project: URL Shortener Project: Word Counter in Four Languages

All tutorials ❯

Paths References

Practice

Try it editor Quizzes How To recipes Tools Glossary

Home › How To › SQL

Search text with LIKE

The % sign matches any run of characters.

Examplesql

Open in editor »

More SQL recipes

Find duplicate values
Get the top N rows per query
Find rows with no match in another table
Calculate a running total
Pivot values into columns with CASE