From the course: SQL Essential Training

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Filter and analyze text data

Filter and analyze text data - SQL Tutorial

From the course: SQL Essential Training

Start my 1-month free trial Buy for my team

Filter and analyze text data

“

- [Instructor] Management at WSDA Music is very impressed and they've been able to discover quite a bit of insight based on the reports that we have presented to them. Thus far, we've filtered quite a bit of numeric data and in very much the same way, we can use operators to return specific text data. So the latest request from WSDA management is to now find out how many invoices were billed to the city of Brussels. How would we go about altering our SQL query to respond to this request? Well, first, let's go down to our WHERE clause and take a look. We're now interested in filtering records to where the BillingCity is equal to Brussels. So let's make this alteration. I'm going to remove our current WHERE clause criteria and say BillingCity equal to Brussels. I'm going to pause here. I've just included a single quote and this is one of the significant differences of numeric versus text data when it comes to filtering.…

Contents