Learn SQL Database Programming

Using the underscore (_) wildcard

There a few ways you can use the underscore (_) wildcard, which represents one character. You can use it to find a value at the beginning, end, or middle of a string. For example, the following query will find all rounds that end with LCS:

USE lahmansbaseballdb; SELECT playerid, yearid, teamid, round, pos FROM fieldingpostWHERE round LIKE '_LCS';

The previous query will give us the results shown in the following screenshot:

As shown in the preceding results, the underscore wildcard returned all rows that ended in LCS. Now, you can see just those results, instead of the many other values that are in the round ...