MySQL

Introduction Of MySQL

Start with MySQL Server

Syntax In MySQL

Select In MySQL

Distinct In MySQL

Where In MySQL

And & Or In MySQL

Order By In MySQL

Insert Into In MySQL

Update In MySQL

Delete In MySQL

Injection In MySQL

Select Limit In MySQL

Like In MySQL

Wildcards In MySQL

Aliases In MySQL

Joins In MySQL

Inner Join In MySQL

Left Join In MySQL

Right Join In MySQL

Union In MySQL

Create DB In MySQL

Create Table In MySQL

DataTypes In MySQL

Normalization

Functions In MySQL

Keys & Level of Abstraction

Codd's Twelve Rules

MySQL subjective question

MySQL Interview question

MySQL Objective question

MySQL FAQS

RDMS FAQS

Oracle Interview Questions

This clause is used for pattern searching string or characters in the specified condtions, they require some characters for searching, they are known as the Wildcard Characteres which provides a easier way to search any related string or character value from the requested column. They can be categories into two ways , they are

Syntax

SELECT * 
FROM tablename 
WHERE Clause 
LIKE 'type_define';

The % define the any number of characters in which lname starting letter is 's' and display the following result.

Example

SELECT *
FROM studinfo 
WHERE lname
LIKE 's%' ;

If we want to add some additional condition like sid>105 then we can compute them also

Example

SELECT *
FROM studinfo 
WHERE sid> 105 AND lname
LIKE 's%' ;

Suppose wo know only the first and last character of any stored value we can also search them using the below command

Example

SELECT *
FROM studinfo 
WHERE lname
LIKE 's%a' ;

In this first character is 's' and last character is 'a' and % define the undefined size of character stored in the specified conditions

Example

SELECT *
FROM studinfo 
WHERE lname LIKE 's%a'
ORDER BY sid ;

The underscore ( _ ) defines one character space of any type can be present which help them to search the requested query

Example

SELECT *
FROM studinfo 
WHERE lname LIKE 's_ _ _ _a';

The above code we have 4 unspecified character between s and a so we have to insert 4 underscore( _ ) to get the desired output

In the above code we can also insert the conditions like sid> 105 and order by fname whose code is given below.

Example

SELECT *
FROM studinfo 
WHERE sid>105 lname LIKE 's_ _ _ _a'
ORDER BY fname;