How do you sort by relevance?

abx_2112

For those who may have faced this issue before:

How did you manage to sort your results by relevance?

Might as well ask: How do you match things looking 'alike' and not 'containing' a string? More specific:

what if i don't want to discriminate between Gäuss, Gauss and Gauz?

Excuse me if this is a silly question, and thanks in advance 🙂

abx_

xblue

as for relevance, MATCH AGAINST is capable of that, but probably not in the way you want.

matching similar strings, I don't think there is an easy way, but you might look into mysql regex.

if you e.g. want 'a' and 'ä' and 'ae' always be treated the same, and 'ss' and 's' and 'z', it should be possible to convert your keyword and use it something like:

SELECT * FROM table WHERE column REGEXP '^{G(a|ä|ae)u(ss|s|z)$';}

LordShryku

And there's always the "like" statement. If you know the string length, that would make things easier. Or the "in" statement....

Select from table where field like 'G%';
OR
Select from table where field like 'G??ss%'
OR
Select * from table where field in ('Gäuss', 'Gauss', 'Gauz');

stolzyboy

and like lords, there is NOT LIKE

Select from table where field NOT like 'G%';
OR
Select from table where field NOT like 'G??ss%'
OR
Select * from table where field NOT in ('Gäuss', 'Gauss', 'Gauz');

gtibok

Sorting by revelance is a huge chalange.
This guys told you how to search,
but if you want something like google than try google.

leetkrew

$sql = "SELECT * FROM `links` WHERE MATCH (`field1`,`field2`) AGAINST ('".$query."*' IN BOOLEAN MODE) LIMIT 0,500";

you may also try IN NATURAL LANGUAGE

NogDog

leetkrew wrote:
$sql = "SELECT * FROM `links` WHERE MATCH (`field1`,`field2`) AGAINST ('".$query."*' IN BOOLEAN MODE) LIMIT 0,500";
you may also try IN NATURAL LANGUAGE

Generally speaking, replying to a thread that is over 5 years old is not especially productive. 😉