MySQL - 部分搜索

Question

Anybody knows how to search the partial words in database.

For Example -

My String is Twenty-first Century Fox

Database column value is 21st Century Fox

How do I get result using MySQL LIKE or LOCATE or any other query?

What I want to match is - "st Century Fox"

Answer 1

A simple solution would be breaking the string to number of words and search using OR and LIKE. In this case.

$keyword  = 'Twenty-first Century Fox';
$keywords = explode($keyword,' ');

$keySearch = array();
foreach ($keywords as $keyword){
    $keySearch[] = 'column LIKE \'%'.$keyword.'%\'';
}

$query = 'SELECT * FROM tableName WHERE '.implode(' OR ',$keySearch);