Need to pull a logID and use it as a variable within storedProc

I need to be able to set the logID for a stored procedure. This works for selecting the correct log

SELECT l.logId
    FROM logs l WHERE l.details LIKE 'FCT%'

Select allOpen in new window

Now I need to take that logID and set it so that I can use it in a query such as

CREATE PROCEDURE reportLogName ()

    BEGIN


     SET @lgID = logID  SELECT * FROM logs l WHERE l.details LIKE 'FCT%';
     SET @s = CONCAT(             
     'select * from logs where logid =',@tbl);

      PREPARE stmt FROM @s;

         EXECUTE stmt;
      DEALLOCATE PREPARE stmt;
        END //

    DELIMITER ;

Select allOpen in new window