Andy
> == relevance ??
>
> ... or define a calculated field for these "relevance"... and order the
> results by this value...
>
> SELECT (sex = 1 AND country = 'CA') AS relevance, sex, country
> FROM table
> WHERE sex = 1
> ORDER BY 1 DESC
>
> ... note the relevance includes all the fields.
Andy
> I am building a user search engine. Now I do not know how to gett
following:
> a mandatory field and a voluntary field
>
> For example I would like to get all female users and those who are from
> canada.
> The results should show all users who are female regardless of nationality
> But it