Consulta para MySQL -- BOOLEAN, complicada

[Jorge Solano]

Comprendo tu mensaje... disculpa, es la desesperación. Necesito un query que haga esto...

The relevance are:

a = name
b = description
c = url

1 – if the keyword are in the 3 colunms a, b and c.
2 – if the keyword are ONLY in a and c.
3 – if the keyword are ONLY b and c.
4 – if the keyword are ONLY in a.
5 - if the keyword are ONLY in b.

Ok, and if we good a few registers with the same relevance, we’ll order by the “hits” DESC.