Skip to main content
Home
  • Tutorials
    • Quality Assurance
    • Software Development
    • Machine Learning
    • Data Science
  • About Us
  • Contact
programsbuzz facebook programsbuzz twitter programsbuzz linkedin
  • Log in

Main navigation

  • Tutorials
    • Quality Assurance
    • Software Development
    • Machine Learning
    • Data Science
  • About Us
  • Contact

MySQL: AND Operator

Profile picture for user arilio666
Written by arilio666 on 11/10/2021 - 11:31

In writing conditions there comes a point where the conditions based on a single term have another need to match it and this is where we will be using the AND operator.

AND operator is an operator which performs the additional condition paired up with the WHERE clause and both need to match in the case of AND operator.

Syntax

SELECT * from tablename WHERE condition1 (comparison) condition2 AND condition3 (comparison) condition4

Let us see this in a real-time example where will be using this customers table for example:

Example

select * from customers where birth_date > '1990-01-01' and points > 1000

So here I am doing a simple operation using AND operator as we can see from the table I'm fetching people who are born after 1990 which we can say greater than that year 1990 with the help of AND operator I further wanted another true condition where people born after the 1990 year also having points greater than 1000.

Related Content
MySQL Tutorial
MySQL: SELECT Statement
MySQL: WHERE Clause
Tags
MySQL
  • Log in or register to post comments

Choose Your Technology

  1. Agile
  2. Apache Groovy
  3. Apache Hadoop
  4. Apache HBase
  5. Apache Spark
  6. Appium
  7. AutoIt
  8. AWS
  9. Behat
  10. Cucumber Java
  11. Cypress
  12. DBMS
  13. Drupal
  14. GitHub
  15. GitLab
  16. GoLang
  17. Gradle
  18. HTML
  19. ISTQB Foundation
  20. Java
  21. JavaScript
  22. JMeter
  23. JUnit
  24. Karate
  25. Kotlin
  26. LoadRunner
  27. matplotlib
  28. MongoDB
  29. MS SQL Server
  30. MySQL
  31. Nightwatch JS
  32. PactumJS
  33. PHP
  34. Playwright
  35. Playwright Java
  36. Playwright Python
  37. Postman
  38. Project Management
  39. Protractor
  40. PyDev
  41. Python
  42. Python NumPy
  43. Python Pandas
  44. Python Seaborn
  45. R Language
  46. REST Assured
  47. Ruby
  48. Selenide
© Copyright By iVagus Services Pvt. Ltd. 2023. All Rights Reserved.

Footer

  • Cookie Policy
  • Privacy Policy
  • Terms of Use