I am looking for a database that supports indexes like this:
select name from table where name Like "%roger%"
Normal (b-tree) based indexes on any database can't work by design for a
LIKE query that starts with
%, as that forces a full scan. Full-text indexes are the alternative for this type of query, or putting your searchable keywords into a different table and indexing that (may or may not be a viable solution, depending on your situation).