I couldn't find this in the documentation. What is the propoer sql to insert into a field with a data type of set? My field has the following set of acceptable values:
GA, TN, SC, NC, AL Assume I am inserting multiple values, such GA, TN, SC. If I separate them with commas, mysql will assume they are separate fields. So, what is the way out of this? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php