This in not my area of expertise but you might also want to checkout
"Overview of the Search Query" in the most recent SDK.
The example that they give follows:
SELECT
"DAV:getcontentlength","urn:schemas-microsoft-com:office:office#Title","
Rank" FROM Portal_Content..Scope() WHERE ("DAV:getcontentlength" >
10000) ORDER BY "DAV:getcontentlength"
Copy and paste it into the search textbox and click Go to see the
results. There is a complete article (nearly 100 pages) that describes
in detail all the options for specifying a Portal Server SELECT search.
If memory serves me, I think that WSS ignores the columns in the first
part of the SELECT. But I think that it does process the other clauses
like WHERE.
So, in your example, maybe you could use something like:
SELECT * FROM Portal_Content..Scope() WHERE
"urn:schemas-microsoft-com:office:office#Name"="abcd" AND
"urn:schemas-microsoft-com:office:office#Title"="egf"
Only a semi-educated guess... Very hard to test on my box where I've
never really setup search.