Implement Basic Full-Text Search

SELECT
  id, title, content
FROM
  posts
WHERE
  to_tsvector('english', title || ' ' || content) @@ to_tsquery('english', 'database & web & dev');

How it works: This query performs a basic full-text search on the 'posts' table using PostgreSQL's built-in text search features. It creates a 'tsvector' (tokenized and stemmed document) from the combined 'title' and 'content' columns and then checks if it matches a 'tsquery' for the terms 'database', 'web', and 'dev'. This allows for more intelligent and efficient keyword searching compared to simple LIKE clauses.