sql pattern matching code example

Example: How is the pattern matching done in the SQL?

SELECT * from Emp WHERE name like ‘b%’;