Match text regardless of order

[Jaguar]

Say my database has a field, description, with the phrase "hello there" in it.

 

When I do a search I want to match "hello there" and "there hello".

 

Is the only way to do it like this?

 

SELECT * FROM table WHERE description LIKE '%hello%' AND description LIKE '%there%';

[Jaguar]

Well I got working like that. Kind of anonying. Is there a better way?

 

$search = mysql_escape_string($_GET['search']);
$sql = str_replace(' ', "%' AND description LIKE '%", $search);
$sql = "description LIKE '%" . $sql . "%'";

$result = mysql_query("SELECT * FROM table WHERE $sql");

[fenway]

You could use a FULLTEXT index on this column.