For this, use MySQL MIN(). Let us first create a −mysql> create table DemoTable1414    -> (    -> BookTitle varchar(40),    -> BookPrice int    -> ); Query OK, 0 rows affected (0.82 sec)Insert some records in the table using insert −mysql> insert into DemoTable1414 values('Deep dive using java', ... Read More

The fastest and easiest way is to use the MySQL BETWEEN keyword. Let us first create a −mysql> create table DemoTable1413    -> (    -> EmployeeName varchar(20),    -> EmployeeJoiningDate datetime    -> ); Query OK, 0 rows affected (0.45 sec)Insert some records in the table using insert −mysql> ... Read More

For this, use Regular Expression in MySQL as in the below syntax −select * from yourTableName where yourColumnName regexp '^[^ ]+[ ]+[^ ]+$';The above query will work when the two words are separated by a space. Let us first create a −mysql> create table DemoTable1412    -> (    -> ... Read More

For this, use FIND_IN_SET() in MySQL and use the value from a custom variable. Let us first create a −mysql> create table DemoTable1411    -> (    -> Value int    -> )    -> ; Query OK, 0 rows affected (0.50 sec)Insert some records in the table using insert ... Read More

To mask data fields, use CONCAT() along with REPEAT(). Here, we will mask data fields with #. Let us first create a −mysql> create table DemoTable1410    -> (    -> Password varchar(80)    -> ); Query OK, 0 rows affected (0.51 sec)Insert some records in the table using insert ... Read More

The event.delegateTarget property in jQuery is used to return the element where the currently-called jQuery event handler was attached.SyntaxThe syntax is as follows −event.delegateTargetExampleLet us now see an example to implement the jQuery event.delegateTarget property −    $(document).ready(function(){       $("div").on("click", "button", function(event){     ... Read More

The nextAll() method in jQuery is used to return all next sibling elements of the selected element.ExampleLet us now see an example to implement the jQuery nextAll() method −    .demo * {       display: block;       border: 3px solid yellow;     ... Read More

The next() selector in jQuery is used to return the next sibling element of the selected element.SyntaxThe syntax is as follows −$(selector).next(filter)Above, the parameter filter is a selector expression to narrow down the next sibling searchExampleLet us now see an example to implement the jQuery next() selector − ... Read More

The contents() method in jQuery is used to return all direct children, including text and comment nodes, of the selected element.SyntaxThe syntax is as follows −$(selector).contents()ExampleLet us now see an example to implement the jQuery contents() method −    $(document).ready(function(){       $("button").click(function(){ ... Read More

The children() method in jQuery is used to return all direct children of the selected element.ExampleLet us now see an example to implement the jQuery children() method −    .demo * {       display: block;       border: 2px solid blue;       ... Read More