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.

More Articles

 

Share your thought



PLEASE DISABLE ADBLOCKER AND SUPPORT US!

Please support us by enabling ads on this page. Refresh

YOU DON'T LIKE ADS, WE ALSO DON'T LIKE ADS!
 
But we have to show ads on our site to keep it free and updated. We have to pay huge server costs, domain costs, CDN Costs, Developer Costs, Electricity and Internet Bill. Your little contribution will encourage us to regularly update this site.