Hmmmm,
> >>> Suppose I have a field named title that contains > >> one > >>> of these > >>> I am a Man > >>> I am a Woman > >>> We are Men > >>> We are Women Why not split this into two fields: pronoun enum('I','WE') gender enum('MAN','WOMAN') OR a SET title SET("I","WE","MAN","MEN","WOMAN","WOMEN) ...and then get your application to parse the various sentences and store the data correctly. (mysql,query) DSL -- Con te partiro, su navi per mari Che io lo so, no, no non esistono piu Con te io li vivro. (Sartori F, Quarantotto E) --------------------------------------------------------------------- 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