if value exists

[b1011]

i am using php and mysql.

 

i need this in Mysql:

if value exists in colum 'gangname' then execute code.

 

any ideas?

 

do you know what i mean?

 

im adding a new row, and i dont want the gangname the same as any other ones, so i need to check if the name exists so i DONT execute code.

[pikemsu28]

use REPLACE instead of INSERT in your query

 

REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a Primary Key or a UNIQUE index, the old row is deleted beore the new row is inserted.

be carefull when using REPLACE, it will delete the existing record and add a new row at the end which will leave spaces in any auto_inc columns.

 

 

http://dev.mysql.com/doc/refman/5.0/en/replace.html

[binindex]

do you mean see if the gang name exists if it does then do this part of code in say php or do this.  Using it like an if?

[pikemsu28]

can you post any code?