SELECT * FROM table WHERE file_format LIKE 'p%$b%.zip'