SELECT some_columns
FROM   some_table
WHERE  name like '%ME%'