Magento addFieldToFilter和addAttributeToFilter用法整理

本文链接：https://blog.csdn.net/oarcher1234567/article/details/49155033

本文详细整理了Magento电商平台中，用于数据过滤的addFieldToFilter和addAttributeToFilter方法的使用，旨在方便开发者快速查阅和理解这两种查询过滤方式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Magento中addFieldToFilter和addAttributeToFilter用法整理,记录下来,防止丢失后再去查找.

//Equals: eq
	$_products->addAttributeToFilter('status',array('eq'=> 1));
//Not Equals - neq
	$_products->addAttributeToFilter('sku',array('neq'=>'test-product'));	
//Like - like
	$_products->addAttributeToFilter('sku',array('like'=>'UX%'));
//Not Like - nlike
	$_products->addAttributeToFilter('sku',array('nlike'=>'err-prod%'));
//In - in
	$_products->addAttributeToFilter('id',array('in'=>array(1,4,74,98)));
//Not In - nin
	$_products->addAttributeToFilter('id',array('nin'=>array(1,4,74,98)));
//NULL - null
	$_products->addAttributeToFilter('description','null');
//Not NULL - notnull
	$_products->addAttributeToFilter('description','notnull');
//Greater Than - gt
	$_products->addAttributeToFilter('id',array('gt'=> 5));
//Less Than - lt
	$_products->addAttributeToFilter('id',array('lt'=> 5));
//Greater Than or Equals To- gteq
	$_products->addAttributeToFilter('id',array('gteq'=> 5));
//Less Than or Equals To - lteq
	$_products->addAttributeToFilter('id',array('lteq'=> 5));