Correl: Sailend: This is exactly what this will do: SELECT controller FROM your_table WHERE col1 = 1 OR col2 = 1 OR col3 = 1 . ;
Correl: Sailend: You are thinking wrong way about it. You don’t need to *exclude* anytuing. You need to *select* only rows you need
Alexader: Salle, let me try this once again
Roig: Salle, let me try and let you know
Correl: Sailend: Define which rows you want to *select* because that directly translates to WHERE clause
Correl: Sailend: You SELECT something FROM some tables WHERE rows match this condition
Melandez: Salle, i am getting all the list of controller which is not correct result
Lautzenheiser: Select controllers from psg.permission where d=1 or d=0 or edit=1 or edit=0 or ind=1 or ind=0 or v=1 or v=0 or ad=1 or ad=0; here is my sql query
Correl: Sailend: You get exactly what you asked for :
Swed: Thats a bit different from what salle suggested.
Correl: Sailend: WHERE d=1 OR d=0 will return all rows where d=1 and all rows where d=0
Slaughter: Salle, no no i need to exclude the controller if all the column value matches to 0
Cermeno: It should only returns 6 controllers name
Correl: Sailend: If you do why did you add OR d=0 . OR edit=0 . etc?
Correl: Sailend: If you do not want to SELECT rows where d=0, edit=0 etc. why did you add OR d=0 . OR edit=0 . ?
Hyon: Salle, i did what you have suggested
Correl: Sailend: No you didn’t
Swatsworth: Thats why i told you i used sub query to exclude to the result
Correl: Sailend: That’s what I suggested: sailend: This is exactly what this will do: SELECT controller FROM your_table WHERE col1 = 1 OR col2 = 1 OR col3 = 1 . ;
Correl: Sailend: Where do you see 0s here?
Correl: Sailend: Stop thinking and talking about excluding results
Lafont: Salle, tell me if i follow your suggestion what output should i get according to your query
Correl: Sailend: Isn’t it obvious?
Correl: Sailend: Try this: SELECT controller FROM your_tbl WHERE d=0;
Jakubov: It will give all the name of controllers having d=0
Dimperio: Salle, no dout on that
Correl: Sailend: Now what about: SELECT controller FROM your_tbl WHERE d=1; ?
Kaestner: It will give me all the list of controller having d 1
Correl: Sailend: Correct! That’s first step
Correl: Sailend: Next one: SELECT controller FROM your_tbl WHERE d=1 OR edit=1; ?
Correl: Sailend: What rows it will return?
Moffit: It will give me list of controller where d matches to and edit matches to 1
Correl: Sailend: Will it return any rows where both d and edit are 0?
Sands: Salle, what if any controller which have d=1 and other field having zero
Correl: Sailend: You tell me :
Viles: Salle, ok got the result thank you, sorry for asking such a stupid question
Correl: Sailend: Nothing to sorry about. As I told you you were thinking about it in reverse way
Correl: Sailend: There is no need to exclude anything. SELECT only rows you want and the rest will be excluded
Notestine: Salle, yes the thing of “excluding” is hovering all around so i couldnot think in that simple way
Correl: Sailend: Like when you go to supermarket you don’t go to the cashier and tell him to exclude all the goods you don’t want. Instead you fill your cart with the goods you want to buy and don’t care about the rest.
Brawner: Salle, that one was great example :
Propp: Salle, way to simpler to understand than my teacher does
Correl: Sailend: Technically in both cases you exclude unwanted items : It is the approach that differs
Schellermann: How come when I’m trying to log in to my mysql server with my root account