Post reply

QOD 8/12/03

  • August 13, 2003 at 3:02 am

    #469692

    Hi folks,

    I'm not sure I understand this.

    The table contains the following:

    

    RecipeName                Description

    ------------------------- ----------------------------------------

    Homemade Chicken Soup     A nice Winter's day chicken broth

    Broiled Hen               Grilled chicken (a souped-up BBQ recipe)

    Chicken Sandwich          A paltry recipe for poultry lovers

    Chicken Broth             A delicious poultry consommé

    Soup a la Chicken         Soup made from chicken.

    and CONTAINS(*, 'chicken AND NOT soup') returns TRUE if any column

    matches. By my reckoning (using T/F to denote True/False match)]

    the above data matches in the following way:

    

    RecipeName  Description  Match?

    ----------- ------------ -------

    F           T            T

    F           F            F

    T           F            T

    T           F            T

    F           F            F

    i.e. 3 matches.

    Mark's explanation implies that "Broiled Hen/Grilled chicken (a souped-up BBQ recipe)"

    matches - could anyone explain to me how? (Or have I completely missed the point?)

    Thanks,

    Sean O'Halpin

  • August 13, 2003 at 3:32 am

    #469694

    To Sean O'Halpin.

    As I understand, description field in second row:

    "Grilled chicken (a souped-up BBQ recipe)"

    matches to request (T), because there is not "soupe" as simple term.

    Iouri.

  • August 13, 2003 at 8:40 am

    #469751

    I really, really like the QOD. Not only is it stimulating, but these discussions are worth getting it wrong.

    Joe Johnson


    Joe Johnson
    NETDIO,LLC.

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply