SELECT * from <таблица> WHERE name LIKE "%%1%"

SELECT f1, f4, f5, f7, f9 FROM `%1`.`Sheet1$`  WHERE f1 LIKE '%3B4-2386G-00-00%';

SELECT f1 AS "Наименование", count() AS "Израсходовано" FROM `%1`.`Sheet1$`  WHERE f1 LIKE '%3B4-2386G-00-00%' ;