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... Link to comment https://forums.phpfreaks.com/topic/2712-or-statement/ 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--] Link to comment https://forums.phpfreaks.com/topic/2712-or-statement/#findComment-9050 Share on other sites More sharing options...
hawaii233 Posted October 22, 2005 Author Share Posted October 22, 2005 Works perfectly, thanks neylitalo! Link to comment https://forums.phpfreaks.com/topic/2712-or-statement/#findComment-9052 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.