complex SQL statement

hello all
for me as a beginner it's a complex statement
I want sql statement that do the following
retrive all records that meet the following condition
name field must contain one or more of the following patterns [%adm%,%use%,%joh%,.....etc].
for example I want employers informations about all employers that names are contain the substrings: [adm OR use OR joh ....]

by the way the substrings are contained in array or comma limited string.
thanks in advance

 

select * from table
where name like '%adm%' or '%use%' or '%joh%';

 

Right. Name with '%adm%'.

 

thank you
your statement will work if I know how many patterns I want to find but the patterns are in array like that
array('adm','use','sar','ali','joh',,,,,,,,,,,,,etc)

but not that what I mean:
I mean something like this :

select * from table1 
where name IN ('%adm%','%use%','%joh%','%sar%',,,,,,,,,,,etc.)

Code (markup):

I want employers informations about all employers that names are contain the substrings: [adm OR use OR joh ....etc] , note that the substrings are contained in array