Guest aikdo Posted December 15, 2005 Share Posted December 15, 2005 Hey does anyone know how to prase a SQL comand to select from a column where column = 1 or 2 or 3 or 4 ect ect... need to filter the results not to show them all , but need it all in one MY SQL statment so i can use ORDER BY... anyone help is needed... Quote Link to comment Share on other sites More sharing options...
Guest aikdo Posted December 15, 2005 Share Posted December 15, 2005 anyone... ok let me clarify i want to write a code that selects all products withing a catagory and its sub catagories, i know how to set it by catagory and i know how to select them in groups but i want them all to be selected in one where i can then just use ORDER BY... WHY is google failing me now... DOES anyone know if this is possible??? Quote Link to comment Share on other sites More sharing options...
goober999 Posted December 15, 2005 Share Posted December 15, 2005 anyone... ok let me clarify i want to write a code that selects all products withing a catagory and its sub catagories, i know how to set it by catagory and i know how to select them in groups but i want them all to be selected in one where i can then just use ORDER BY... WHY is google failing me now... DOES anyone know if this is possible??? here you go select * from table_name where column_a in (2,3,4) select * from table_name where columnb_b in ('text1','text2','text3') Good Luck /Goober Quote Link to comment Share on other sites More sharing options...
Guest aikdo Posted December 15, 2005 Share Posted December 15, 2005 your a champ goober just what i wanted and it only took 2 hours to find it :D Quote Link to comment Share on other sites More sharing options...
Guest estelle Posted December 15, 2005 Share Posted December 15, 2005 www.mysql.com has all the answers... Quote Link to comment Share on other sites More sharing options...
Guest aikdo Posted December 15, 2005 Share Posted December 15, 2005 I was in the process of searchin there when goober posted ... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.