Database IntegrationLesson 52Free preview

MySQL Where

This lesson is part of Node.js · All levels

Summary

The WHERE clause filters the line so that only those that meet certain conditions are removed, changed, or deleted. Comparison operators like =, >, LIKE, and IN make filters more flexible. Always use the placeholder parameter so that the condition value does not insert a malicious SQL.

Key points

WHERE selects the line based on certain conditions
Common operators: =,!=, >, <, Between, LIKE, and IN
Combine the condition with AND and OR carefully.
Use the placeholder for the dynamic value of the app

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.