Filtering Data / Using the LIKE Operator

SELECT Code, Name
FROM country
WHERE Code LIKE 'B_R'


Code Name
BGR Bulgaria
BHR Bahrain
BLR Belarus

The underscore is used just like %, but instead of matching multiple characters the underscore matches just a single character.