Two feild unique

[Pests]

This is kinda hard to explain, when i INSERT info into the database i want to have two unique feilds, but not seperate. Its more clear to what im trying to do if i show you an example:

id|column1|column2
1|frank|bob
2|frank|joe
3|bob|joe
4|jim|frank
5|joe|bob

Now, if i try to insert "frank|jerry" it will work, if i try to insert "betty|wilma" it will work, "wilma|frank" will also work. Now, if i try to insert "frank|joe" it will NOT work because #ID: 2 already has that, but "joe|frank" WILL work because its different then #ID 2. Can anyone help me with this? (i know i could get around it with some php coding: select the info before i insert it and see how many rows were returned. But i rather leave it up to mysql) Post if you have any questions.

[tomhath]

That's what unique indexes are for:

http://www.mysql.com/doc/en/CREATE_INDEX.html

When you try to insert a duplicate it will fail, check mysql_error if you need to know when it happens.

[Pests]

Is this the line:

A column list of the form (col1,col2,...) creates a multiple-column index. Index values are formed by concatenating the values of the given columns.

How would i turn that into sql?

CREATE UNIQUE INDEX index_name ON tbl_name (column1,column2)

Would that be it?

[tomhath]

You've probably tried it by now, but yes, that should do it.