how to get best search results AND , OR , LIKE

Question

Query #1:

---

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

but not works good , and when I try splited this sql:

Query #2:

---

SELECT DISTINCT `title`
    FROM `table`
    WHERE (
    `title
` LIKE '%this is search%'
    )

or

Query #3:

---

SELECT DISTINCT `title`
    FROM `table`
    WHERE (
`title` LIKE '%this%'
    AND `title` LIKE '%is%'
    AND `title` LIKE '%search%'

or etc ...

returns different results

Answer 1

You are providing too little information, but from what I can see, you are looking for mySQL's fulltext search functions.

• Boolean full-text searches allow you to require and exclude words using + and -

• Natural language searches match against a list of words, and return a weighted result set.