Wildcards are "placeholders" for when you want to leave some aspects of a filter open for variation. Say you have a tabel of books, and you want to SELECT all the books that start with "The": since you can hardly know all book titles with "The " at the beginning by heart and there could be also more new books being released in the future that start with "The ", you cannot (reasonably) do a "WHERE title = 'The giver' OR title = 'The holy bible' OR ... ". This is where Wildcards come into play: by saying "WHERE title = 'The %' " you fetch all the books that have a title that starts with "The ", without having to know every single one of them. And if you put this wildcard (the % in your query) at the beginning or a string, say "WHERE lastname = '%son' ", you SELECT all records that end in "son", like "Eriksson", "Stevenson" etc
10/10, no time wasted.
Underrated channel
Wisdom knowledge to the point of info. I owe you for the same.
thanks,I watched all videos about SQL reaaaaaaallly helpful 😍
Novice SQL user, thanks for this!
Thanks Cody! Love the simplicity
Thanks alot. how can we remove duplicated then?
In ORACLE I use Fetch at the end of a query instead of Top or Limit
wtf does selecting more columns do if you want the unique name and age pairs?
He forgot to say use group by instead
Thanks man, valuable content.
What does one do in a SQL occupation that would make off-peak hours relevant? I mean I genuinely don't know, I'm still studying.
Hi Cody, Do you offer a class on SQL and data analitics
its crispy Cody thanks
bang nanya kenapa ya, ukuran size mysql cpanel sy sangat besar, padahal ukuran asli size phpmyadmin nya sangat kecil ?
What are wildcards?
Wildcards are "placeholders" for when you want to leave some aspects of a filter open for variation. Say you have a tabel of books, and you want to SELECT all the books that start with "The": since you can hardly know all book titles with "The " at the beginning by heart and there could be also more new books being released in the future that start with "The ", you cannot (reasonably) do a "WHERE title = 'The giver' OR title = 'The holy bible' OR ... ". This is where Wildcards come into play: by saying "WHERE title = 'The %' " you fetch all the books that have a title that starts with "The ", without having to know every single one of them. And if you put this wildcard (the % in your query) at the beginning or a string, say "WHERE lastname = '%son' ", you SELECT all records that end in "son", like "Eriksson", "Stevenson" etc
Nice
Thank u Master
I thought I might see something like use a CTE...