Let us first create a table −mysql> create table DemoTable (    Name varchar(50),    Score int ); Query OK, 0 rows affected (1.02 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Sam', 45); Query OK, 1 row affected (0.22 sec) mysql> insert into DemoTable ... Read More

For this, you can use the BETWEEN keyword. Let us first create a table −mysql> create table DemoTable (    ArrivalDate date ); Query OK, 0 rows affected (0.93 sec)Let’s say the current date is 2019-08-31.Insert some records in the table using insert command −mysql> insert into DemoTable values('2019-04-21'); Query ... Read More

For this, you need to set sql_mode to 'STRICT_TRANS_TABLES’. This mode issues a warning when an invalid value is inserted but inserts the same value. Let us first create a table −mysql> create table DemoTable (    Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    Name varchar(50),    Gender char(1) ... Read More

For this, you can use ORDER BY IF(). Let us first create a table −mysql> create table DemoTable (    Name varchar(50),    Score int ); Query OK, 0 rows affected (0.72 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris', 98); Query OK, 1 ... Read More

Let us first create a table −mysql> create table DemoTable1 (    Id int ); Query OK, 0 rows affected (1.26 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1 values(100); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable1 values(110); Query OK, 1 ... Read More

For this, use aggregate function MAX() along with the GROUP BY clause. Let us first create a table −mysql> create table DemoTable (    Id int,    Value1 int,    Value2 int,    Value3 int,    Value4 int ); Query OK, 0 rows affected (0.61 sec)Insert some records in the ... Read More

The easiest way to achieve this is by using REGEXP. Let us first create a table −mysql> create table DemoTable (    Id varchar(50) ); Query OK, 0 rows affected (0.77 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('John123'); Query OK, 1 row affected ... Read More

Let us first create a table −mysql> create table DemoTable (    Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    Name varchar(50) ); Query OK, 0 rows affected (0.62 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(Name) values('Chris'); Query OK, 1 row affected (0.17 sec) ... Read More

We can use the HAVING clause rather than the WHERE in MySQL. Let us first create a table −mysql> create table DemoTable (    Name varchar(50),    Price int ); Query OK, 0 rows affected (0.79 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris', ... Read More

To display a single random row, use the RAND() with LIMIT. Here, LIMIT is used to fetch the number of records, since we want only a single row, therefore use LIMIT 1. Let us first create a table −mysql> create table DemoTable (    Id int NOT NULL AUTO_INCREMENT PRIMARY ... Read More