In this chapter you will learn:
About like statement
Syntax of like statement
Example of like statement
About like statement
SQL like statement is used to search specific data with where clause and use some wildcards.
Syntax of like statement
SELECT column_name from table_name where column_name like pattern
Example of like statement
select * from humanresources.employee where title like 'p%'
select * from humanresources.employee where title like '%p%'
SUMMARY
In this chapter, you have learned about SQL like statement. In the next chapter you will learn about wildcards so click on NEXT button to go to the next chapter.