Final answer:
To show all fields from the "cats" table where the name starts with 'B', use the SQL query: SELECT * FROM cats WHERE name LIKE 'B%'; This includes the wildcard character (%) to match any sequence of characters following 'B'.
Step-by-step explanation:
To display all fields from the table "cats" where the name begins with a B, you would write an SQL query. Assuming you're using a SQL-based database, the command you would use is:
SELECT * FROM cats WHERE name LIKE 'B%';
This command selects all columns (denoted by the asterisk *) from the table "cats". The WHERE clause specifies the criteria to be met for the rows to be selected, which in this case, is any name that starts with 'B'. The percent sign (%) is a wildcard character in SQL, which represents any sequence of characters. So, 'B%' matches any string that starts with the letter 'B'.