I am looking to get a collection of attribute text values (not option values) from this particular table: catalog_product_entity_varchar
given a particular attribute_id
(and entity_type_id
). Preferably I would like to use magento collection models and not include any other information apart what is on this table.
I would like to follow this up by querying a particular value
from this table as well as using LIKE based wildcards queries.