Function addExpressionAttributeToSelect as defined in Mage_Eav_Model_Entity_Collection_Abstract (/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php) allows us to use MySQL functions in Magento collection. Here is an example of using MYSQL IN() clause in magenot more product collection at once :
Showing posts with label select. Show all posts
Showing posts with label select. Show all posts
2 Nov 2013
31 Oct 2013
Magento: How To Select, Insert, Update, And Delete Data?
Suppose, I have a database table named ‘test‘ with the following fields:-
id : int, auto increment, primary key
title : varchar
content : text
status : 1
Suppose, I have a module named ‘mytest‘. Here follows the code to select, insert, update, and delete data from the ‘test‘ table.
id : int, auto increment, primary key
title : varchar
content : text
status : 1
Suppose, I have a module named ‘mytest‘. Here follows the code to select, insert, update, and delete data from the ‘test‘ table.
Subscribe to:
Posts (Atom)