select * from nome_da_tabela where nome like '%vinicius%'
The% symbol indicates that there may be anything, that is, any name containing vinicius before or after will be selected.
To search for all names beginning with Vinicius for example, you would do the following:
select * from nome_da_tabela where nome like 'vinicius%'