Basic SQL Topics
SQL can be very simple
Consider the dataset on the right, and assume you’d like to see all cities that have the word “Mount” somewhere in the City name:
SELECT *
FROM database_table
WHERE City LIKE ‘%Mount%‘
The LIKE keyword will look through the City column and see if any part of that data has ‘Mount’ any place within it. Depending on where you place the % will determine how SQL searches for the text you’re interested in looking for. If you entered ‘Mount%’ then it will look for data within the City column that start with ‘Mount’.