Okay.
So we saw not equals, which is the opposite of the equal sign.
Now we're going to look at not like and as you probably guessed, not like is the opposite of like.
So just to review, we haven't used like all that much, but it is pretty common and important one.
It allows us to match patterns in strings usually, so we can do things like select, let's do all titles
and we'll just do title from books where title like and we can do things like we'll start off, how
about all books that contain?
How about all books that start with the letter W Just like that.
And if we just do W on its own, remember, that doesn't really give us anything unless it's an exact
match of the letter.
W But we use the percent sign there as a placeholder.
And now this says all books that start with the letter W and anything afterwards.
Or we could expand that to be any title that has the letter W.
So that's it for review.
That's how like works.
We match these patterns and anything that matches this pattern where these are placeholders, the percent
signs mean anything goes there.
Anything that matches this will be returned.
So all of these contain a W somewhere.
All right.
So that brings us to not like which, as you have probably surmised by now, it will do the opposite.
So here's an example.
Select all books with titles that don't start with the letter W.
So rather than the exclamation point equals like we had for not equals, we just use the word not space
like.
And then in this case w sign means something that has a W and then anything after that.
And then we're negating that with not so this in effect says select all the book titles that don't start
with the letter W.
So if we go back recall this which gives us these.
Well, actually, let me get rid of the percent sign at the beginning.
These are the three books that start with the W What We Talk About When We Talk About Love, where I'm
calling from and white noise.
And if we go and just add note now we get all book titles excluding these three.
All right, so that's it for not like hopefully you liked that rather than not liked it, I guess.
All right.
Well, let's just move on.