Suppose i have the following sql table:
my_table (col_1, col_2, col_3, col_4)
and the folowing user input for the search:
The above input means the folowing: search col_1 for value_1, col_2
for value_2 and value_3 in all columns.
Besides this i need some scoring (this is used for sorting the results
by their relevance).
A match in col_1 will be 4 points, col_2 will be 3 points, col_3 will
be 2 poits and the last one 1 point.
All the results will be sorted by computing this score.
For example: matching in col_1 for value_1 (+4), ...