Hello, in this video, we are going to take a look at the where property for filtering. So imagine if we, you know, this table these, you know, users, maybe they have some sort of, you know permissions. So you have like a regular user super user, that sort of stuff. So let's actually, you know, format this. So go to the structure, go to we want to add a nova, you know, section here, so we want to go to where is it? No, come see what I'm looking for.
Now, there we go. Add Column, so just want to add one more column. And this is going to be var char, this is going to be a C chord type. So we're gonna have we're going to have a default value, so the default value will just Be regular user specified now, we don't need anything 16 really. And if we go to browse, there we go. So what we want to do is set Batman and Yoda to a super user, which just had, you know, high privileges.
Technically, obviously, we're not doing any user system yet. But you'll get, you know, a rough idea. So imagine if we only want to select users, or rows, that has a type of super user to do this really simple. Just put, where then you specify the actual, you know, column that you check in. So it's going to be type, and then say, petitioner, super user. And now if I run it, as you can see, it only gets them now, if I was to change this to use that you should only get the first one like so.
And if we put something That doesn't exist, it will get non all rows like so. And you can easily put a variable here as well. So you could easily put $1 type equals per you there. And you could just put dollar type here. They all do the same thing. So I'm gonna switch this back.
And there you go. That's really all you need to know regarding the where clause. This allows you to check you know, the type of data that you're getting and only get certain data. And that's it. If you have any questions, feel free to pop me a message, and I look forward to seeing you in the next video.