Hello, in this video, we are going to take a look at the like property for pattern search the where property which I covered in the previous video. If you haven't checked that out, I highly recommend checking that out that just checks does a particular column have a specific value if it does select that row, if not, then ignore it. Whereas the like allows you to do a bit of a pattern check. So if you look at the data we got here, I want to only select the users that end with an N. And to do that, we what we want to do is we want to get rid of this, we still need a where so this is saying where this column so the column will be used a name. Instead of saying equal we say Lloyd and then we just put quotation marks and we put cent.

And so this basically says there can be anything before the end and that if it doesn't matter what it is, if I run it as you can see it Get a hold of it. Whereas if I was to change this to, for example, get rid of that, as you can see now, he won't get it. And never let me get this. And watch what happens if I put a you know, put my let's say my last initial at the end, what will happen now, he still won't get it because we are saying that he has to end in an end, if we have the option to say that it can end in something else and percent at the end. And there you go, it will get that as well I still get this because it doesn't matter if the knocking at the end, it just gives us that extra flexibility to change this back.

And obviously if I was to put a For example, this will get all of them. Because all of them have been a somewhere. There's a lot more advanced formatting that you can you know pattern search that you can do using the like property where I'm going to do provided a link with this video that will show you all of the extra little things that you can do. But the principle is exactly the same really cool stuff. You can also check you know if it has, you know, only get rows that have let's say he ends in n for example, but only has three characters before it for the last stuff you can do by providing link with all that extra information for watching and I look forward to seeing you in the next video.