{"id":3913,"date":"2025-06-06T20:10:13","date_gmt":"2025-06-06T20:10:13","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&p=3913"},"modified":"2025-06-07T09:55:51","modified_gmt":"2025-06-07T09:55:51","slug":"sql-comparison-operators","status":"publish","type":"cposts","link":"https:\/\/w3buddy.com\/blog\/notes\/sql\/sql-comparison-operators\/","title":{"rendered":"SQL Comparison Operators"},"content":{"rendered":"\n

Comparison operators help you compare values<\/strong> in the WHERE<\/code> clause to filter data.<\/p>\n\n\n\n

\ud83d\udd39 Common Comparison Operators<\/h2>\n\n\n\n
Operator<\/th>Meaning<\/th>Example<\/th><\/tr><\/thead>
=<\/code><\/td>Equal to<\/td>WHERE salary = 50000<\/code><\/td><\/tr>
<><\/code> or !=<\/code><\/td>Not equal to<\/td>WHERE department <> 'HR'<\/code><\/td><\/tr>
><\/code><\/td>Greater than<\/td>WHERE salary > 60000<\/code><\/td><\/tr>
<<\/code><\/td>Less than<\/td>WHERE age < 30<\/code><\/td><\/tr>
>=<\/code><\/td>Greater than or equal to<\/td>WHERE experience >= 5<\/code><\/td><\/tr>
<=<\/code><\/td>Less than or equal to<\/td>WHERE age <= 40<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\ud83d\udd39 Usage Example<\/h2>\n\n\n\n
SELECT * FROM employees WHERE salary >= 50000 AND department <> 'Sales';<\/code><\/code><\/pre>\n\n\n\n
\ud83e\udde0 Quick Recap<\/h2>\n\n\n\n
    \n
  • Use =<\/code> and <><\/code> (or !=<\/code>) for equality and inequality<\/li>\n\n\n\n
  • Use <<\/code>, ><\/code>, <=<\/code>, >=<\/code> for range checks<\/li>\n\n\n\n
  • Essential for filtering rows in your queries<\/li>\n<\/ul>\n\n\n\n
    \u2705 Master these to control exactly which rows you get!
    <\/p>\n","protected":false},"excerpt":{"rendered":"
    Comparison operators help you compare values in the WHERE clause to filter data. \ud83d\udd39 Common Comparison Operators Operator Meaning Example = Equal to WHERE salary = 50000 <> or != Not equal to WHERE department <> ‘HR’ > Greater than WHERE salary > 60000 < Less than WHERE age < 30 >= Greater than or […]<\/p>\n","protected":false},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[952,979],"class_list":["post-3913","cposts","type-cposts","status-publish","hentry","category-notes","category-sql"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/3913","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=3913"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=3913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}