MySQL Where Clause

    0
    681

    Great day Everyone, This tutorial is all about MySQL Where Clause I will tell you and teach you all you need to know about the MySQL Where Clause As a programmer you need to know MySQL Where Clause so let’s get started:

    A WHERE Clause is added to MySQL query, the MySQL engine compares each record in the table with the condition specified in the WHERE Clause.The MySQL engine display only those records that satisfy the specified condition.

    Syntax:

    MySQL table(tblemployee)

    idEmp_NameEmp_CodeEmp_DesignationEmp_joinnig_date
    1Clive Dela Cruz10806121Software Developer2018-02-01
    1Andrew Braza10806860Software Testing2015-10-15
    1Clide Marcellana10806865HR2016-12-22
    1Rey Tejada13406121Accountant2019-03-01

    Ex:

    Output

    Clive Dela Cruz

    Operators in the where clause :

    OperatorDescription
    =Equality
    !=Inequality
    <Less than
    <=Less than or equal
    >More than
    >=More than or equal
    Between minWithin the range
    AND maxmin to max
    IS NULLIs a NULL Value
    IS NOT NULLIs not a null value

    Comparison operators are used in a query with a WHERE clause to test if a specified condition is met. When the evaluation is TRUE the query will return the data, otherwise nothing will be returned.

    That’s it! I hope you learn something today about MySQL Where Clause 

    If you have any comments or suggestions about MySQL Where Clause Please message us Directly:

    Other Articles you might read also:

     

    Looking for more source code? Type your keyword here here!

    LEAVE A REPLY

    Please enter your comment!
    Please enter your name here

    This site uses Akismet to reduce spam. Learn how your comment data is processed.