hi. i have the following that works... in that it does a replace on the row.
replace into appTBL (appName, universityID) values(%s,%s)... i'm trying to figure out how to do the replace on the row if a given column is not equal to a certain value.. i've tried... replace into appTBL (appName, universityID) values(%s,%s) where foo != 66 and various combinations but i'm getting an error regarding the 'where' clause... i've searched the mysql site, as well as google, and can't quite figure out how to accomplish this.. is there another, more efficient/better way to resolve this... any thoughts/comments... thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]