Full Text Search help.....

[Brian]

Hi,

I'm doing a Full Text Search on a table. I running the following script at command line:
------------------------

\u db1

SELECT FirstName, MI, LastName
FROM contract
WHERE STRCMP(EMail, '[e-mail]') = 0;


------------------------

And when it spits the answer out I get the following output:

FirstName MI LastName
Brian Cardarella

Now, I understand that when I use 'SELECT FirstName, MI, LastName' it will print that information to the screen, but I plan on doing a batch process with a TCL script with a variable for the string in question. (i.e. '[e-mail]') and I don't want 'FirstName MI LastName' printed every other line in my output. Is there a way to tell MySQL to not print that line or another searching method I should use?

Thanks!