MySQL Database Management System > MySQL Statements and Clauses

MySQL - Insert and Select Statement With Like Clause

28.8k

To pick data from a database, use the SELECT statement. The data is saved in a result table known as the result-set.

In a WHERE clause, the LIKE operator is used to look for a certain pattern in a column. There are two wildcards that are frequently used with the LIKE operator: The percent sign (%) can be used to represent zero, one, or more characters. One single character is represented by the underscore sign ( ).

Wildcards can be used in the WHERE clause of a SELECT, INSERT, UPDATE, or DELETE statement with the MySQL LIKE condition. This gives you the ability to match patterns.

Inserting one or more rows into a database table with specified table column values is done with the insert command. The insert statement is the first DML instruction run once a table is created.

Learner's Ratings

4.3

Overall Rating

  • 60%
  • 28%
  • 2%
  • 0%
  • 10%

Reviews

B
Boobalan A
4

I want this course for english. Classes are superb. but not understand few places, because I don't know hindi.

A
Aish Dubey
5

Perfect for beginners and explained in Hindi

M
Mohsin Salim Kazi
5

Great for beginners

C
Chandan Kumar
5

very good

S
Saurabh Virkud
4

Thank you learnvern ..

V
Vikash Chaudhary
5

This site is very usefull for everyone.

V
vj tricks
5

This course is very good

S
Sanjeev Rana
5

Please provide course notes

A
Ankit Patel
5

Thank you learnvern and learnvern is best platfrom a lern a new skill. again thank you.

Y
Yadav Aakash
5

learnvern doing greate job...Thank you teacher's content team.

Show More
Recommended Courses
Course Content
Enroll For Free