16-LIKE Operator & Wildcard Characters | NOT LIKE Operator | ESCAPE Character | SQL Queries

Are you new to SQL and looking to learn the basics quickly? Look no further! This tutorial is designed for beginners and will teach you the fundamentals of SQL .
So what are you waiting for? Grab your coffee and let's get started!
Complete SQL Tutorial Playlist- • SQL / MySQL Tutorial
Key Moments-
LIKE Operator - 01:14
Wildcard Character - 02:44
NOT LIKE Operator - 09:15
ESCAPE Character - 11:00
📚 SQL Practice Questions -
codeera.netlif...
🔶Create Employee Table
codeera.netlif...
🔶Insert Data into Employee Table
codeera.netlif...
Connect with us on different platforms
✅ Visit Our Website: codeera.netlif...
✅ Subscribe us on TH-cam: / @codeera2020
✅ Follow us on Instagram: / codeera_
✅ Follow us on Telegram: t.me/joingroup...
📌15-BETWEEN & NOT BETWEEN Operator | IN & NOT IN Operator in SQL
• 15 - SQL BETWEEN & NOT...
📌14 - AND, OR, NOT Operators in SQL | Logical Operators
• 14 - AND, OR, NOT Oper...
📌13 - WHERE Clause in SQL | Types of Operators | Comparison Operator
• 13 - WHERE Clause in S...
📌12 - SELECT Command in SQL | DISTINCT | FROM Clause | AS - Alias
• 12-SELECT Command in S...
📌11- Constraints in SQL | DBMS
• 11 - Constraints in SQ...
⭐Part 1:Top 9 SQL queries for interview -
• Top 9 SQL queries for ...
⭐Part 2:Top 9 SQL queries for interview -
• PART 2 : Top 9 SQL que...
⭐Top SQL Interview Question
• Top SQL Interview Ques...
⭐Interview SQL Query On Joins
• Interview SQL Query On...
⭐DBMS vs RDBMS
• DBMS vs RDBMS | What i...
⭐SQL Query To Swap Value Of Male and Female In Single Statement
• SQL Query To Swap Valu...
#sql
#sqlcourse
#sqlforbeginners
#datamanagement
#database
#sqltraining
#sqltutorial
#dataanalytics
#dataanalysis
#learnsql
#sqlqueries
#sqlprogramming
#onlinelearning
#techskills
#elearning
#onlinetraining
#programming
#coding
#careerdevelopment
#beginners
#MySQL
#databasemanagement
#DBMS
#techtutorials
#sqlforbeginners
#sqltutorial
#sqlcourse
#sqltraining
#simplilearn
#sqlintroduction
#sqlfullcourse
#oracledatabase
#oracle
#oraclesql
#ask4help
#learncoding
#like
#wildcard

[@CodeEra2020]

Answer 6 - SELECT * FROM employee WHERE progress LIKE '%\%%';

[@AshutoshShukla-y1e]

I was getting error 1364 field Id doesn't have default value when I inserting values in new column progress= '30%' and employee_code ='Jack_101'

[@022-SasisekharreddyObulareddy]

SELECT *
FROM employee
WHERE progress LIKE '%\%%';

[@it_21_debjitghosh42]

Thanks

[@lalithadwarapureddi3283]

Select * from employee where progress like '%\%%';

[@SaiVamsi-g4k]

Select * from employee where progress like '%\%%'

[@adarshranjan9254]

select * from employee where progress LIKE '%\%%';

[@preetihalder4758]

SELECT * FROM EMPLOYEE WHERE employee_table LIKE '% ! % %' ESCAPE ' ! ' ;

[@CodeEra2020]

Right Answer.👍

[@radhikapatidar4844]

there should be column name instead of table name ?@@CodeEra2020