We can use LIKE with wildcards to filter for certain patterns in text. The % wildcard replaces any number of characters in a string of text. To select any dog whose name starts with B, try:

SELECT dog_id, name FROM dogs WHERE name LIKE 'B%';