LIKE "M*", not LIKE "M%" surely? J277 spec? I know W3 Schools uses %, but it confuses the kids. And % is not allowed on the mark schemes I've seen for use as a wildcard.
It’s a complicated one. Short answer is that wildcards are not specifically mentioned in J277 so hopefully they’re not needed. Once I’m fairly confident that is the case after a couple of exam series I’ll remove it from the video. Longer answer - the % wildcard is used for LIKE on most serious DBMS but not all of them. J276 specifically mentioned the % wildcard in its SQL section of the specification, along with the LIKE command, but not an example of its use for clarification. The only use of it I am aware of for the SQL commands there is for LIKE. They also mentioned * of course, which is 100% the wildcard for SELECT. Finally - I’m not aware of an exam question that needed LIKE in the answer so we lacked clarity from OCR on what they wanted. Please do point me to one of you have found it though.
Thanks for this, though - why is it like "A%" and not "A*"? Also, would be handy if you had a link to the previous video in the description - not always easy to find!
Never seen it explained so simply and clearly thank you so much
This guy is helping me achieve grade 9
did you get the 9?
the fact I legit have a test about this tommorow and I was struggling so much on the topic this helped loads THANK U
Thank you so much for this one sir, very quick, helpful and easy to understand!
Thank god for this
bro your the best man! really easy to understand, keep it up!
Your videos are so helpful, thanks sm for keeping it short and simple, great for a quick revision
nice video and got straight to the point
Easy to understand and very helpful thanks
Pls upload the rest of the spec, these videos are amazinggg
10/10 much better than Craig and Dave
those guys yap so much
The result shouldn't be included in your enquiry right?
LIKE "M*", not LIKE "M%" surely? J277 spec? I know W3 Schools uses %, but it confuses the kids. And % is not allowed on the mark schemes I've seen for use as a wildcard.
It’s a complicated one.
Short answer is that wildcards are not specifically mentioned in J277 so hopefully they’re not needed.
Once I’m fairly confident that is the case after a couple of exam series I’ll remove it from the video.
Longer answer - the % wildcard is used for LIKE on most serious DBMS but not all of them. J276 specifically mentioned the % wildcard in its SQL section of the specification, along with the LIKE command, but not an example of its use for clarification. The only use of it I am aware of for the SQL commands there is for LIKE. They also mentioned * of course, which is 100% the wildcard for SELECT. Finally - I’m not aware of an exam question that needed LIKE in the answer so we lacked clarity from OCR on what they wanted. Please do point me to one of you have found it though.
thank you so much
May I ask what software are you using
I used this setup support.khanacademy.org/hc/en-us/articles/202483430-What-software-program-equipment-is-used-to-make-Khan-Academy-videos-
Thx i made excellent notes
thanks
Does this apply for the aqa 8525 specification for the gcse computer science paper 2?
Guess I'll find out soon if I don't get a reply regardless
@@asarma0804 did you find out?
thanks man
Thanks for this, though - why is it like "A%" and not "A*"?
Also, would be handy if you had a link to the previous video in the description - not always easy to find!
its just how sql is made,
cheers 👍
Goat