SQL
Public
Search Multiple Columns
Search several text columns with LIKE placeholders.
#sql
#search
#like
#prepared-statements
SQL
SELECT id, title, description
FROM snippets
WHERE title LIKE :search_title
OR description LIKE :search_description
OR language_code LIKE :search_language
ORDER BY updated_at DESC;Notes
Use prepared statements. Do not concatenate raw user input into SQL strings.
