CREATE TABLE foo (
    column1  varchar(...),
    column2  integer,
    KEY(column1)
);
SELECT column1, column2 FROM foo WHERE column1 IN ('text1', 'text2', '
+text3');
[download]

In between of course, you need to populate the table. Once.