SQL Like Statement

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%'

like statement example
select * from humanresources.employee where title like '%p%'

like statement example2

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.

 

Share your thought