Skip to main content

MySQL practical Tutorials part 10- MySQL logical AND, logical OR and BETWEEN operator.

 MySQL logical AND, logical OR and BETWEEN operator practical queries.

=======================================================================================================================


Logical AND

SELECT title, author_lname, released_year FROM books

WHERE author_lname='Eggers';

 

SELECT title, author_lname, released_year FROM books

WHERE released_year > 2010;

 

SELECT  

    title, 

    author_lname, 

    released_year FROM books

WHERE author_lname='Eggers' 

    AND released_year > 2010;

 

SELECT 1 < 5 && 7 = 9;

-- false

 

SELECT -10 > -20 && 0 <= 0;

-- true

 

SELECT -40 <= 0 AND 10 > 40;

--false

 

SELECT 54 <= 54 && 'a' = 'A';

-- true

 

SELECT * 

FROM books

WHERE author_lname='Eggers' 

    AND released_year > 2010 

    AND title LIKE '%novel%';

Please note, as of MySQL 8.0.17, the && operator is deprecated and support for it will be removed in a future MySQL version. Applications should be adjusted to use the standard SQL AND operator.

If you're using MySQL 5.7 or older, which most of you are if you're using GoormIDE, then you don't have to worry about this right now. But, in newer versions of MySQL (8.0.17 and newer) you will need to replace && with AND.

=====================================================================


Logical OR

SELECT 

    title, 

    author_lname, 

    released_year 

FROM books

WHERE author_lname='Eggers' || released_year > 2010;

 

 

SELECT 40 <= 100 || -2 > 0;

-- true

 

SELECT 10 > 5 || 5 = 5;

-- true

 

SELECT 'a' = 5 || 3000 > 2000;

-- true

 

SELECT title, 

       author_lname, 

       released_year, 

       stock_quantity 

FROM   books 

WHERE  author_lname = 'Eggers' 

              || released_year > 2010 

OR     stock_quantity > 100;

Please note, as of MySQL 8.0.17, the || operator is deprecated and support for it will be removed in a future MySQL version. Applications should be adjusted to use the standard SQL OR operator.

If you're using MySQL 5.7 or older, which most of you are if you're using GoormIDE, then you don't have to worry about this right now. But, in newer versions of MySQL (8.0.17 and newer) you will need to replace || with OR.


=====================================================================


Between

SELECT title, released_year FROM books WHERE released_year >= 2004 && released_year <= 2015;

 

SELECT title, released_year FROM books 

WHERE released_year BETWEEN 2004 AND 2015;

 

SELECT title, released_year FROM books 

WHERE released_year NOT BETWEEN 2004 AND 2015;

 

SELECT CAST('2017-05-02' AS DATETIME);

 

show databases;

 

use new_testing_db;

 

SELECT name, birthdt FROM people WHERE birthdt BETWEEN '1980-01-01' AND '2000-01-01';

 

SELECT 

    name, 

    birthdt 

FROM people

WHERE 

    birthdt BETWEEN CAST('1980-01-01' AS DATETIME)

    AND CAST('2000-01-01' AS DATETIME);

=====================================================================


Labels:
Location: Ahmednagar, Maharashtra, India

Comments

Post a Comment

Popular posts from this blog

Add, remove, search an item in listview in C#

Below is the C# code which will help you to add, remove and search operations on listview control in C#. Below is the design view of the project: Below is the source code of the project: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace Treeview_control_demo {     public partial class Form2 : Form     {         public Form2()         {             InitializeComponent();             listView1.View = View.Details;                   }         private void button1_Click(object sender, EventArgs e)         {             if (textBox1.Text.Trim().Length == 0)...
Post a Comment
Read more

display files and directories in Listview

Below is the C# code which displays all files and directories in listview control with their file size and creation date. If it is file then it also displays the extension of the file e.g. .txt, .jpg etc Below is the design view of the project: Listview to display files and directories with size and date created Below is the source code of the project: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using System.IO; namespace search_in_listview {     public partial class Form1 : Form     {         public Form1()         {             InitializeComponent();                   }         private void button1_Click(object sender, EventArgs ...
Post a Comment
Read more

Add worklog in Jira using Python

 Below is the Python code to add the worklog in Jira. You need to install a request library for this. Here is the code: import requests from requests.auth import HTTPBasicAuth import json url = "https://your jira address here/rest/api/2/issue/ticket_number/worklog" auth = HTTPBasicAuth("username", "jira access token") headers = {     "Accept": "application/json",     "Content-Type": "application/json" } payload = json.dumps({     "comment": {         "content": [             {                 "content": [                     {                         "text": "This is for QA Testing",                         "type": "text"                     } ...
Post a Comment
Read more