从不同的数据库行中选择

Question

The title might not be the best fit for this post, I'm sorry about that! I've got a problem when selecting result from the database. I got 3 rows in a table called "test1", "test2" and "test3" with the values true or false. How do i select all results with the value of 1? i dont want to combine them like:

WHERE test1 = 1 AND test2 = 1 AND test3 = 1.

I want to get all results with the value of 1.

Answer 1

If you mean columns then i don't see any problem with doing it the way you've done it.

SELECT * 
FROM tablename 
WHERE test1 = 1 AND test2 = 1 AND test3 = 1

Update #1

CREATE PROCEDURE nameofprocedure(
   IN vartest1 INT,
   IN vartest2 INT,
   IN vartest3 INT
)
BEGIN
   SELECT * 
   FROM tablename 
   WHERE test1 = vartest1 AND test2 = vartest1 AND test3 = vartest1

END;

Update #2

Then to call the procedure use;

CALL nameofprocedure(1, 0, 1); or
CALL nameofprocedure(1, 1, 1); //Mix what ever you like