SQL
Perform Basic Full-Text Search with LIKE
Discover how to perform simple full-text searches in SQL using the LIKE operator and wildcards (%) to find records matching partial strings within text fields.
SELECT id, name, description FROM products WHERE name LIKE '%search_term%' OR description LIKE '%search_term%';
How it works: This query performs a basic full-text search using the `LIKE` operator. The `%` wildcard matches any sequence of zero or more characters. By placing `%` before and after `search_term`, it finds records where `name` or `description` contain the specified term anywhere in the string. This is a simple but widely used method for search functionalities.