How to search 471 strings in a table I want to make a SELECT * FROM of 471 strings in table rows, but is not working.

SELECT * 
FROM table 
WHERE user_id IN (SELECT id 
                  FROM table2 
                  WHERE user_id = '(bla)|(bla2)|...|(blaN)') 
                    AND field3 IN (SELECT id 
                                   FROM table2 
                                   WHERE field4 = 'bleh');


I want to know if is correct search many strings in a same query?
Use IN()

WHERE user_id IN ('bla','bla2', 'blaN')