Results 1 to 3 of 3

Thread: select

  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Question Unanswered: select

    I have to select from table some data.
    On one of columns i have list(key:1,2,3,4,...).
    I need select by one of components from this list:
    Select * from tbl ... but where key=2(to example) can't help me.
    What can i use?
    Thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    This table organization is a problem. It is called 0NF (or chaos, or zero normal form).

    The best option is to fix the underlying problem, making a child table that contains one row for each of the possible values in your list. That is called 1NF, or first normal form.

    Short of that fix, you have a real problem. You can resort to doing table scans using the LIKE keyword, but those should only be an absolute LAST resort!

    -PatP

  3. #3
    Join Date
    Mar 2004
    Posts
    3

    Thanks

    Thanks!
    That what i need.

Posting Permissions

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