LIKE operator in MySql

LIKE operator in MySql

SUMMARY

Like operator with wildcard character in mysql.

WHAT IS LIKE OPERATOR IN MYSQL

In this video we will learn about Like operator with wildcard character in mysql.We use like operator for pattern search.There are two wildcard character " % " and " _ ".% is used to find from zero to any no of character._ is used to find for only one character.

PREREQUISITE

In the above video first we login our mysql server . Then check all database list and select our preferred database.you select your database as per your requirement. In our case we select techrideradmin database . Then select the table list within the database. In our case we select department table. Now fetch all records form the table.

EXAMPLE OF LIKE OPERATOR

We have solved some queries in the above video.

1)Fetch the records whose first letter of ename is "A". For that purpose we use % wildcard .

2)Fetch the records whose first two letters of ename is "AS".For that purpose we use % wildcard .

3)Fetch the records whose last letter of ename is "F".For that purpose we use % wildcard .

4)For any particular letter within the word we use _ character.

Thanks for watching.Visit Website : techrideradmin.blogspot.com