1
00:00:00,180 --> 00:00:00,600
Okay.

2
00:00:00,600 --> 00:00:04,740
So we saw not equals, which is the opposite of the equal sign.

3
00:00:04,770 --> 00:00:11,220
Now we're going to look at not like and as you probably guessed, not like is the opposite of like.

4
00:00:11,340 --> 00:00:16,350
So just to review, we haven't used like all that much, but it is pretty common and important one.

5
00:00:16,590 --> 00:00:26,160
It allows us to match patterns in strings usually, so we can do things like select, let's do all titles

6
00:00:27,480 --> 00:00:37,680
and we'll just do title from books where title like and we can do things like we'll start off, how

7
00:00:37,680 --> 00:00:40,110
about all books that contain?

8
00:00:40,350 --> 00:00:45,090
How about all books that start with the letter W Just like that.

9
00:00:46,050 --> 00:00:51,330
And if we just do W on its own, remember, that doesn't really give us anything unless it's an exact

10
00:00:51,330 --> 00:00:52,110
match of the letter.

11
00:00:52,110 --> 00:00:56,070
W But we use the percent sign there as a placeholder.

12
00:00:56,490 --> 00:01:01,080
And now this says all books that start with the letter W and anything afterwards.

13
00:01:01,470 --> 00:01:05,519
Or we could expand that to be any title that has the letter W.

14
00:01:06,360 --> 00:01:07,530
So that's it for review.

15
00:01:07,740 --> 00:01:08,820
That's how like works.

16
00:01:08,820 --> 00:01:14,010
We match these patterns and anything that matches this pattern where these are placeholders, the percent

17
00:01:14,010 --> 00:01:16,080
signs mean anything goes there.

18
00:01:17,220 --> 00:01:19,320
Anything that matches this will be returned.

19
00:01:19,530 --> 00:01:22,020
So all of these contain a W somewhere.

20
00:01:22,710 --> 00:01:23,220
All right.

21
00:01:23,220 --> 00:01:30,410
So that brings us to not like which, as you have probably surmised by now, it will do the opposite.

22
00:01:30,420 --> 00:01:31,650
So here's an example.

23
00:01:31,740 --> 00:01:35,480
Select all books with titles that don't start with the letter W.

24
00:01:35,490 --> 00:01:43,530
So rather than the exclamation point equals like we had for not equals, we just use the word not space

25
00:01:43,530 --> 00:01:44,220
like.

26
00:01:44,490 --> 00:01:51,870
And then in this case w sign means something that has a W and then anything after that.

27
00:01:52,170 --> 00:01:58,890
And then we're negating that with not so this in effect says select all the book titles that don't start

28
00:01:58,890 --> 00:01:59,910
with the letter W.

29
00:02:00,330 --> 00:02:05,910
So if we go back recall this which gives us these.

30
00:02:05,910 --> 00:02:08,400
Well, actually, let me get rid of the percent sign at the beginning.

31
00:02:09,060 --> 00:02:13,710
These are the three books that start with the W What We Talk About When We Talk About Love, where I'm

32
00:02:13,710 --> 00:02:15,210
calling from and white noise.

33
00:02:16,170 --> 00:02:23,460
And if we go and just add note now we get all book titles excluding these three.

34
00:02:23,760 --> 00:02:32,070
All right, so that's it for not like hopefully you liked that rather than not liked it, I guess.

35
00:02:32,430 --> 00:02:32,790
All right.

36
00:02:32,790 --> 00:02:33,870
Well, let's just move on.