Essential Question: How can I retrieve data if I don't know the exact word I am searching for?
Mastery Objectives:
SWBAT create queries when they don't know the entire string by using wild cards in SQL.
Resources: Computer Operator video - https://www.youtube.com/watch?v=JQ5mRfi6kMk
Directions: Try the following queries to search the table using the SQL Editor and the Customers table: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_like and take a screenshot and paste it into google docs. Write a description of your results. Submit your google doc to google classroom. Complete all items. These may not work because we are using an older version of SQL. If they don't work, you can type them in google docs.
SELECT * FROM Customers WHERE City LIKE '_ondon';
Create a query searching for the partial name of Cork using the method above
Create a query searching for the partial name of Sevilla using the method above
Create a query searching for the partial name of any country using the method above
SELECT * FROM Customers WHERE City LIKE 'L_n_on';
Create a query searching for the partial name of Madrid using the method above
Create a query searching for the partial name of Elizabeth Lincoln using the method above
Create a query searching for the partial name of any contact name using the method above
SELECT * FROM Customers WHERE City LIKE '[bsp]%';
Create a query searching for the partial name of Consolidated Holdings using the method above
Create a query searching for the partial name of Peter Franken using the method above
Create a query searching for the partial name of any customer name using the method above
SELECT * FROM Customers WHERE City LIKE '[a-c]%';
Create a query searching for the partial name of Godos Cocina Típica using the method above
Create a query searching for the partial name of Bernardo Batista using the method above
Create a query searching for the partial name of any city using the method above
SELECT * FROM Customers WHERE City LIKE '[!bsp]%';
Create a query searching for the partial name of São Paulo using the method above
Create a query searching for the partial name of Giovanni Rovelli using the method above
Create a query searching for the partial name of any city using the method above
SELECT * FROM Customers WHERE City NOT LIKE '[bsp]%';
Create a query searching for the partial name of Anchorage using the method above
Create a query searching for the partial name of Yoshi Latimer using the method above
Create a query searching for the partial name of any city using the method above