Magento 1.9 Catalog Price Rules ‘Is One Of’ Condition Not Working – Fix

Default Magento Buy X Get Y Free rule works only for one product. Means, if customer buy X="SKU-OW-1" customer will get free Y="SKU-OW-1". if you want to set another product as a Y then you need to create custom module for that. There are several free extensions available on Magento Connect that will do things for you.

This might help you to create rule: http://www.magentocommerce.com/wiki/3_-_store_setup_and_management/shopping-cart-price-rule-recipes#buy_1_get_1

So the problem is in the getOperatorCondition() in app/code/core/Mage/Rule/Model/Resource/Rule/Condition/SqlBuilder.php

            case '!{}':
            if (preg_match('/^.*(category_id)$/', $field) && is_array($value)) {
                $selectOperator = ' IN (?)';
            } else {
                $selectOperator = ' LIKE ?';
            }
            if (substr($operator, 0, 1) == '!') {
                $selectOperator = ' NOT' . $selectOperator;
            }
            break;

on line 67

To solve this problem you can hack the file core changing LIKE with %LIKE% or just simply add % in condition like:

sku contains %1513437%