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

Reply via email to