Jump to content

Archived

This topic is now archived and is closed to further replies.

hawaii233

OR statement

Recommended Posts

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...

Share this post


Link to post
Share on other sites

[!--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--]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.