Filter with Wildcards in SQL | SQL Bits | Kovolff

Опубликовано: 04 Октябрь 2024
на канале: kovolff
59
1

%: Wildcard / placeholder for an infinite number of characters
z.B. SELECT forename LIKE '%o'
This filter gets all forenames that end with an 'o'

_: Wildcard for 1 character
z.B. SELECT initial LIKE 'a_'
This gets all initials that begin with 'a' and are two letters long

When using wildcards use the SQL keyword LIKE instead of =

Formula 1 Data: https://ergast.com/mrd/db/#csv
Formula 1 data

#sql #like #wildcards #filters