Basic Full-Text Search with SQL LIKE Operator

SELECT
  article_id,
  title,
  content_preview
FROM
  articles
WHERE
  title ILIKE '%sql query%'
  OR content ILIKE '%database optimization%'
ORDER BY
  article_id DESC
LIMIT 10;

How it works: This query illustrates a basic approach to full-text search using the `LIKE` operator (or `ILIKE` for case-insensitivity, common in PostgreSQL). The `%` wildcard matches any sequence of zero or more characters. This allows users to search for keywords within text columns like `title` or `content`. While more advanced full-text search solutions exist in most databases, the `LIKE` operator provides a straightforward and widely compatible method for simple search functionalities in web applications.