如何在没有重复和单词顺序的情况下将文本存储在数据库中无关紧要？

Question

So I want to store searches on my site in a database and I want them to be unique even though the order of words doesn't matter for me for example:

some words

and

words some

are the same for me, and I just want to update the time of the last search.

So is there a way to do this in SQL (like UNIQUE) or should I find a solution in a server side language ?

And thanks in advance.

Answer 1

I don't know if there is a better way to do this, but the only way I can think is that in PHP you split the string by spaces and then order it alphabetically:

$words = explode(" ", $keywords);
sort($words);
$sorted_keywords = implode(" ", $words);

Then when you store/search from database you'll always be using the same string no matter which order the words WERE in.