MySQL LIKE and MATCH results query

Can开发者_如何学Python someone explain why

column  LIKE '%board%'

returns more results than

MATCH (column) AGAINST('board' IN BOOLEAN MODE)

is it because match against ignores words like 'Blackboard', 'Backboard' etc

Is there away to get MATCH AGAINST return Blackboard, backboard etc?

MATCH (column) AGAINST('keyword... will match against the literal string provided, where as LIKE "%keyword%" will match if a word contains the string provided.

This should do the trick for you:

MATCH (column) AGAINST('board*' IN BOOLEAN MODE)

Source: http://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html

There are a lot of good examples of search queries there.