By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table data1 (buyer varchar2(30));
insert into data1 (buyer) values ('Pete Hansen');
1 rows affected
select * from data1 where buyer = 'Pete Hansen';
| BUYER |
|---|
| Pete Hansen |
select * from data1 where buyer like 'Pete Hansen';
| BUYER |
|---|
| Pete Hansen |
select * from data1 where buyer like 'Pete Hans_n';
| BUYER |
|---|
| Pete Hansen |
select * from data1 where buyer like 'Pete Hans_n%';
| BUYER |
|---|
| Pete Hansen |