ok another weird question from me btw using mysql 4.0.2 but upgradin soon so if ya help plz specify version if pos
ok here's the deal i have a db all set but sometimes i insert 1000s of entries at a time and most are dupes but is there a way that if the entry is a dupelicate on one column it would check if the incoming row has a lower value there and if it does then update it or if the current value is N/A and the new one has something then update it
i was looking on inserts and on duplicate but seems it only starts in the newest versions but also if using that not sure how to check and compare the entries of the current and incoming and then use only if incoming is lower etc..
hopefully someone can understand the problem i know it's a little jibberish sry :P just trying to learn hehe
thx for any suggjustions