In previous posts, I have written about different ways of using SQL, from entering, updating and deleting data to making queries using different filters. In this post, I will write about another type of filter for queries called the LIKE operator.

The LIKE operator is specifically used with the WHEN clause. This operator is used when one is looking for a specific pattern within a column. For an example, we are working in a clients table. This is the table where any personal information like name, birthdate, address and phone number might be found. We might be searching the table…

Malcolm Katzenbach

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store