User Profile

Collapse

Profile Sidebar

Collapse
imaginit
imaginit
Last Activity: Nov 17 '09, 05:19 PM
Joined: Nov 6 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • imaginit
    replied to Help with SELECT id IN query
    in MySQL
    Thanks everyone! I am going to give this a try and see how it works out.

    Lance
    See more | Go to post

      Leave a comment:

    • imaginit
      started a topic Help with SELECT id IN query
      in MySQL

      Help with SELECT id IN query

      I need to build a query that queries products based on multiple categories.

      A product can have multiple categories attached to it and I want to query products that are only in ALL of the selected categories.

      My query might look like:

      SELECT * FROM products INNER JOIN products_catego ries.productid = products.produc tid WHERE products_catego ries.categoryid IN (1,5,13)

      The results I want is...
      See more | Go to post
      No activity results to display
      Show More
      Working...