how to get best search results AND , OR , LIKE

[FraddyBrarymn]

Query #1:\[code\]SELECT DISTINCT `title`FROM `table`WHERE (`title` LIKE '%this is search%')OR (`title` LIKE '%this%'AND `title` LIKE '%is%'AND `title` LIKE '%search%')OR (`title` LIKE '%this%'OR `title` LIKE '%is%'OR `title` LIKE '%search%')LIMIT 0 , 10\[/code\]but not works good , and when I try splited this sql:Query #2:\[code\]SELECT DISTINCT `title` FROM `table` WHERE ( `title` LIKE '%this is search%' )\[/code\]orQuery #3:\[code\]SELECT DISTINCT `title` FROM `table` WHERE (`title` LIKE '%this%' AND `title` LIKE '%is%' AND `title` LIKE '%search%'\[/code\]or etc ...returns different results