SELECT WHERE clause

[SharkBait]

Am I right to assume that when you use wildcards (%) in a SELECT WHERE clause, that it will only match based on order of given terms?

 

IE:

 

SELECT * FROM name LIKE ('%this%that%')

 

Will only match: 'something like this is like that', or ' this thing is that thing' etc?

 

Where as

SELECT * FROM name LIKE ('%that%this%')

will not match any of the above, since the order of terms are reversed?

 

I would assume that FULLTEXT search would be the ideal thing to use, right? Since the terms being looked up can be in no particular order?

 

 

[Alex]

Yes.

[SharkBait]

Cool thanks