Using non static string in the AGAINST part

[Rickard Engström]

Hi

I have a question for you MySql people. Since I'm quite new to MySql and particularly to Full text search matters, I need to know if I'm right in this. Read somewhere that you can only use static strings in the AGAINST part, as in the firast example below:

---------------
SELECT id, header, MATCH(header,content) AGAINST('Supernova') AS score
FROM tbl_stellar WHERE MATCH(header,content) AGAINST('Supernova');
---------------

which should mean that this is not possible:
---------------
SELECT id, header, MATCH(header,content) AGAINST(myVariable) AS score
FROM tbl_stellar WHERE MATCH(header,content) AGAINST(myVariable);
---------------

The above examples assumes that the proper table and Full text index are created and that the second one is for example called from within a stored procedure with myVariable as IN parameter.

Can someone please give me a hint in this?

Regards, Rickard