problem with update statement

2005-04-22 Thread ragan_davis
Hello, all: In a MyISAM table, I have a column named "MAC", of type VARCHAR(17). This field is used to hold MAC addresses of computers' network interface cards. These MAC addresses are in the form "XX:XX:XX:XX:XX:XX", where X can be either a number or an uppercase letter. I can run "select

Re: problem with update statement

2005-04-25 Thread ragan_davis
Thanks for the info. I am using 4.0.24, so maybe this is the problem. I was able to get around this by first checking if the mac field was empty, but I will look into upgrading mysql to a more current version. thanks - Original Message - From: [EMAIL PROTECTED] Date: Monday, April 25,