mysql - SQL find rows where column is LIKE -

i want find rows have particular name on it. problem of rows have prefix: "(obsolete)" or "(obsolete) "

so name john, have 3 rows:

john (obsolete)john (obsolete) john 

how write query can find rows match name knowing prefix there, , want those?

would able use sql wildcards in statement?

select * customers name '%john';