Please we are going to discuss about the like operator in SQL. Make sure we are working on the SQL series and this is a disease. So now the like operator is used to is used to in a where clause to search for a specific admin in a column how you use the where clause for suppose you always use select a static from spirit, okay, it's showing all the records if you are if you say that where city name equals to London it will give you that this report because you're saying that with your jobs, but if you want to search by platform, how if you if I say that oh please show me the record Which has the IE discarding or the character or the string as you can see is available in the city's party. If I say See, if I say so as you can see L is available in the learner.

Okay, now how it was you use the okay and say I'm just select I'm saying staring from students. Now I'm saying where ethnicity now this is the like, yes I'm talking about the like, like operator search the pattern from the table how and like because this is strange there so I i have to say this crowd with that good percentage Sam saying show me all the record which has a starting at the character control in def now that gets you sourcing anything is not well, if I say l definitely it will give you the learner control. First, it is giving you the letter R suppose, if you say, P, Control Enter, so it's giving you the Paris because P is available at the beginning of the string. So now if you use the percentage sign here, Ctrl, enter, it's also giving you can see a Ctrl, enter, it's giving you all the record.

That means I am saying that please follow the statement and that has the A at the beginning and also the end because as you know that it is a Available in the Paris and he also available in Karachi. So this is a so that's why is showing you the results okay? If If I see that oh please find me the results now if I use one now search the A use the percentage sign in the Control Enter products now you can see it's giving you the records why I'm saying I'm saying just discard the first first character then start from second and find the paper. Now if I see if I use to time design a shirt design this is okay who came to the school that means I'm saying eliminate or are you added two words, or discovered two words of a character. Now if I enter the calculator button, so now as you can see, it's not showing me anything.

If I use our personalities, it's showing you the records because r is available in the third character say R or R R. And if I see that I eliminate the three character and fine I, if we give you three more so as you can see, it is showing the five reverse. If I say, our control in that it's not simply if I say a and it's show you the one record, because the you are saying that 123 this chord C character and find a from the column so this is a column thing, this way You are you can search anything from a table so it's totally depend upon you. If you if I'm saying that oh please find the record a percentage and I that means at all hinder, is not showing you anything because you are saying that find the city which has a and I says you can see in the Rashi in the second in the karate as it is a senior to start from here And from so now I'm saying that to start from a and from I interpret as evidence you're showing you the record search totally depend upon you or how is your logic and how you are performing the pattern and how you creating the pair for those two, three.

So I think this is enough for us to be able to have similar topics. So thank you for watching.