[fairyfar@bogon postgresql]$ psql postgres
psql (19devel)
Type "help" for help.

test=# create table t1(a char(3));
CREATE TABLE
test=# insert into t1(a) values ('xyz'), ('uv');
INSERT 0 2

test=# select * from t1 where a like 'uv';
 a
----
(0 rows)

test=# select * from t1 where a = 'uv';
 a 
----
 uv
(1 row)

test=# select * from t1 where a like 'uv%';
 a 
----
 uv
(1 row)