Prevent duplicate record

There is no way to check it without using a select.

Code:

SELECT EXISTS(SELECT * FROM yourTableName WHERE yourCondition);

I would make sure that both columns are index.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )