Timeline for HELP with SQL WHERE syntax
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Mar 25, 2017 at 18:11 | history | suggested | wogsland | CC BY-SA 3.0 |
grammar fixes
|
| Mar 25, 2017 at 17:47 | review | Suggested edits | |||
| S Mar 25, 2017 at 18:11 | |||||
| Nov 19, 2012 at 14:07 | answer | added | onlineapplab.com | timeline score: 1 | |
| Nov 18, 2012 at 18:35 | answer | added | SteB | timeline score: 2 | |
| Nov 17, 2012 at 19:01 | history | tweeted | twitter.com/#!/StackDBAs/status/269878167450304512 | ||
| Nov 17, 2012 at 14:29 | history | edited | Hannah Vernon♦ | CC BY-SA 3.0 |
improved formatting
|
| Nov 17, 2012 at 14:21 | comment | added | TIW | @Dezso & Martin: Many thanks, i've learnt something today! Didn't realise you could use parentheses in SQL code. Thanks Guys - i'll report back! | |
| Nov 17, 2012 at 14:21 | comment | added | TIW | @horse_with_name: yes appreciate that, but I've got to keep with the existing structure! | |
| Nov 17, 2012 at 14:13 | review | First posts | |||
| Nov 17, 2012 at 23:12 | |||||
| Nov 17, 2012 at 14:04 | comment | added | András Váczi |
Without seeing your actual query and returned results it is har to tell anything. However, AND has a higher precedence over OR, which means in a AND b OR c AND d a&b and c&d are evaluated first and get then ORd. Anyway, if you suspect that your expression isn't quite that you want, you can always use parentheses to group subexpressions. That way it can even be more readable.
|
|
| Nov 17, 2012 at 14:03 | comment | added | Martin Smith | Just apply the brackets in your pseudo code to your actual code. | |
| Nov 17, 2012 at 14:01 | comment | added | user1822 | You shouldn't be storing comma separated values in a column in the first place. | |
| Nov 17, 2012 at 13:58 | history | asked | TIW | CC BY-SA 3.0 |