MySQL Database Management System > MySQL Statements and Clauses

MySQL - Insert and Select Statement With Like Clause

17.9k

Start a new search

To find content from modules and lessons

Suggested Topic: Latest Top

Topic		Like	Replies	Views	Activity
Loading...

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.5

Overall Rating

Reviews

ROBERT PHILIP

The course is designed very well and all concepts were explained properly with examples

DURGESH LAL KAVI

4 star

Omkar kiran shinde

good teaching

Ashihrii Phimu

wonderful to learn from all the teachers. keep up the good work. Thank you

Vinod Kumar Kulkarni

Very useful session for professionals and students.

Swapnil Chilwant

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

NAVNEET MAHESWARI

EASY TO UNDERSTAND IN OUR OWN LANGUAGE

shrutika jain

Thank you so much Meet Shah Sir , It was really great and easy to understand I had clear my doubts in your study. thanks' again ...

Abhijeet Anil Waghmare

This MySQL Database course is really helps you for beginner level. Almost all the basic concepts clear in that course in very simple ways. I strongly recommend this course.

Rohan Varshney

awesome

Recommended Courses

Free हिन्दी

PHP Course For Beginners

30787

4.2 Enroll For Free

Free हिन्दी

Core Java Course

61018

4.3 Enroll For Free

Free हिन्दी

Advanced PHP with MVC Programming with Practicals

33081

4.4 Enroll For Free

Free हिन्दी

Java Programming Advance Course

67430

4.2 Enroll For Free

MySQL - Insert and Select Statement With Like Clause

Start a new search

What is select statement in MySQL?

Can we use like in MySQL?

What is like command in MySQL?

What is the function of the insert operation?

Learner's Ratings

Reviews

ROBERT PHILIP

DURGESH LAL KAVI

Omkar kiran shinde

Ashihrii Phimu

Vinod Kumar Kulkarni

Swapnil Chilwant

NAVNEET MAHESWARI

shrutika jain

Abhijeet Anil Waghmare

Rohan Varshney

Recommended Courses

PHP Course For Beginners

Core Java Course

Advanced PHP with MVC Programming with Practicals

Java Programming Advance Course

Course Content

Introduction to MySQL

MySQL Environment Setup

What is Data

What is Database

What is DBMS (Database Management System)

Introduction to SQL and its Query Types

MySQL - Numeric Datatypes

MySQL Constraints

MySQL - Create, Drop and Show Database

MySQL - Create Table Statement

MySQL - Insert and Select Statement With Like Clause

MySQL - Arithmetic and Logical Operators

MySQL - IN and NOT IN Clauses

MySQL - NULL and NOT NULL Clauses

MySQL - ORDER BY and LIMIT Clauses

MySQL - AS, CONCAT, DISTINCT, GROUP BY and HAVING Clauses with Aggregate Functions

MySQL - Update and Delete Statements

MySQL - Alter Table Statement

MySQL - Rename, Truncate and DROP Statements

MySQL - Foreign Key

MySQL - Joins

MySQL - View

MySQL - Function

MySQL - Stored Procedure

MySQL - Trigger

Database Normalization

Assignment : MySQL Database Management System

MySQL Interview Question Part 1

MySQL Interview Question Part 2

MySQL Interview Question Part 3

Course Summary