Return true from a stored procedure

[raydona]

Hi, I have never created a stored procedure so please bear with me. I wish to create a stored procedure where if a condition is met true is returned, else false is returned, something like:

CREATE PROCEDURE SomeName(IN X VARCHAR(15), IN Y VARCHAR(30))

BEGIN

SELECT A, B

FROM Table

//Go through table and

IF A == X AND B == Y return true, else return false

END;

 

How can I achieve this? Further, how can I display the bool result in the statement:

  $res = mysql_query("call SomeName($textA, $textB)");

  if (!mysql_query($res,$con))

  { die('Error: ' . mysql_error());

  }

I will be grateful for all help.

[minus4]

procedure sp_test(blah, blah)
begin

declare a INT default 0;
DECLARE b INT DEFAULT 0;
DECLARE answer INT DEFAULT 0;

SELECT a,b INTO a,b FROM table;

IF (a=X AND b=Y) THEN
SET answer = 1;
ELSE
SET answer = 0;
END IF;

SELECT ANSWER;

end;

 

you could change the int for a bool, but you get the idea ! :-)