This is a snippet of my query:\[code\]and ( ADDR_FULLTEXT like upperstreets1))\[/code\]Whenever i execute the query this is a part of, it executes in about 0.05 seconds. This is perfect!But, when I do the following:\[code\]and ( ADDR_FULLTEXT like upperstreets1) AND ADDR_FULLTEXT like upperstreets2))\[/code\]it results in a 20 second query. Why is the difference this big, and how can solve this?What the rest of the query basically does, is selecting multiple fields from a view (ADDR_FULLTEXT is one of them). There also is another like, just like this one. Maybe i'm doing something really wrong here, and maybe therefor there is a better way of doing this.FYI: A PHP loop generates this query, which results from an explode of a search query. Every word is parsed in this query resulting in 1 or more of the same "like" in 1 query. Another like is generated the same way, but this is always 1 like, never more, never less.