MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

8.0.36

create table manufacturers (id serial, name text) select 'Logistics' name union all select 'TE CONNECTIVITY'

Records: 2  Duplicates: 0  Warnings: 0

select * from manufacturers

id
name

1
Logistics

2
TE CONNECTIVITY

select name
from manufacturers
where instr('Logistics spa', name)

name

Logistics

select name
from manufacturers
where locate(name, 'Logistics spa')

name

Logistics