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
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