Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: amota
  • Order by date
  1. amota

    how to select records that are a group?

    Thanks to all for your responses. What I need to know is the exact group. For example, If I look for (1,2,3) it should return ItemID=1 If I search for (1), it should return none. If I look for (1,2), it should return itemID=3
  2. amota

    how to select records that are a group?

    Hi, I have a table like this: ITEMID CODE 1 1 1 2 1 3 2 1 2 3 2 4 3 1 3 2 4 3 where every item is a set of codes. For example, ItemID 1 = (1,2,3) ItemID 2 = (1,3,4) ItemID 3 = (1,2) ItemID 4 = (3) How can I know if an item exists? For example, if (1,2,3) exists or if (1,2) exists? I'm...
    • amota
    • Thread
    • Replies: 9
    • Forum: MySQL
  3. amota

    how to select records that are a group?

    Hi, I have a table like this: ITEMID CODE 1 1 1 2 1 3 2 1 2 3 2 4 3 1 3 2 4 3 where every item is a set of codes. For example, ItemID 1 = (1,2,3) ItemID 2 = (1,3,4) ItemID 3 = (1,2) ItemID 4 = (3) How can I know if an item...

Part and Inventory Search

Back
Top