Re: Passing db names to a stored proc in MySQL 5

[Rory McKinley]

SGreen@stripped wrote:
<snip>
> You were so close! Try it more like this:
> 
> SET sSQL=CONCAT('SELECT * FROM ', passed_in_db_name, '.sites WHERE 
> site_name=?');
> 
> PREPARE query_statement from sSQL
<snip>

Doh!

I cannot believe that I didn't think of that - seems I was being dense 
after all!

Thanks Shawn will give it a try

Rory