Need to insert SQL without duplicates

php mysql sql codeigniter rss

Add a UNIQUE constraint to those two columns.

php mysql sql codeigniter rss

ALTER TABLE `feed_items` ADD UNIQUE INDEX `constraint` (`link`, `remote_id`);

php mysql sql codeigniter rss

You can use ON DUPLICATE for avoiding such conditions: Check: http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html

Hope it helps