hawaii233 Posted October 22, 2005 Share Posted October 22, 2005 hi, I want to ask if it is possible to make the following statement: SELCET * FROM WHERE xyz AND wer OR mnb So generally I want to have if xyz and wer are true it takes these and otherwise it takes the mnb after the OR part. I hope I made somehow clear what I mean? Further I wanted to ask I gonna have a table with two ID's, both primary keys like 1 2 1 3 1 4 2 2 2 3 This table might have about 60.000-70.000 entries, is that possible or are there constraints regarding waiting time? thks for the help... Quote Link to comment Share on other sites More sharing options...
neylitalo Posted October 22, 2005 Share Posted October 22, 2005 [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] * FROM `table_name` WHERE (xyz AND wer) OR mnb [!--sql2--][/div][!--sql3--] Quote Link to comment Share on other sites More sharing options...
hawaii233 Posted October 22, 2005 Author Share Posted October 22, 2005 Works perfectly, thanks neylitalo! 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.