Results 1 to 2 of 2

Thread: query array

  1. #1
    Join Date
    May 2008
    Posts
    3

    Unanswered: query array

    Hi
    How do I find certain information from an array.
    EG.
    I have ----- '{"frog", "horse")'
    and I have another entry with the following array '{"horse", "camel")'
    how would I find all entries which have a "horse" in them for example.

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Well, if you need to query against the contents of an array field, then the data probably shouldn't be in an array. An array is a form of de-normalization, in this case.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •