MySQL存储过程搜索另一个表

I am totally new to Stored Procedures, but know that this could be more efficient than trying to write PHP+MySQL code each time I need to do something like this. I am totally new to Stored Procedures, but know