GURUS - SHOW TABLES & SQL_CALC_FOUND_ROWS

[Peter Larb]

Good morning

APOLOGIES: I have placed this code here as it is inside a stored proc, but alsio because I had no success in the "general" category.

I wish to do the following:

1. return an integer (0 or 1) whether a table exists in the database
otherwise I will create the table

Problem: instead of returning an integer I am being returned the "table
name" if it exists, or a NULL.

Now I understand that I need to use "SQL_CALC_FOUND_ROWS" but I am
unsure of how to implement that here.

Can anyone help ?

Thanks

Peter

My code so far:

DELIMITER $$;

DROP PROCEDURE IF EXISTS `Research`.`spTableExists`$$

CREATE PROCEDURE `spTableExists`(tableName varchar (5))
BEGIN
DECLARE MyTable VARCHAR(512);

SET @MyTable = concat('SHOW TABLES FROM MyDatabase LIKE ',"'",
tableName, "%'");

PREPARE stmt1 FROM @MyTable;
EXECUTE stmt1;
DEALLOCATE PREPARE stmt1;

SELECT FOUND_ROWS();

END$$

DELIMITER ;$$

Peter Larb