<div>
check for sounds like or soundex functions 
</div>


check for sounds like or soundex functions

<div>
soundex doesn't work with cyrilic
</div>


<div>
Soundex is also optimized for names and may behave unexpected for general pattern matching.<br />
<br />
Sorry, nothing you can do in MySQL.<br />
<br />
You need to solve this problem programatically.
</div>


Soundex is also optimized for names and may behave unexpected for general pattern matching.

Sorry, nothing you can do in MySQL.

You need to solve this problem programatically.

<div>
explode() the rows<br />
make an array of search terms<br />
loop through each row for a match
</div>


explode() the rows
make an array of search terms
loop through each row for a match

<div>
<div class="content wysiwyg-content">
I have text field with some keywords in it (with fulltext index) and some rows... I want to ask mysql to give me the best 10 rows containing words closest to some keywords<br />
<br />
Example:<br />
Rows: 1: &quot;googlee ggooogle google&quot; 2: &quot;googgle yahhoo msn&quot; 3: &quot;some other keywords&quot;<br />
I ask for best matches with &quot;google yahoo&quot; and mysql should give me only row 2.
</div>
</div>


I have text field with some keywords in it (with fulltext index) and some rows... I want to ask mysql to give me the best 10 rows containing words closest to some keywords

Example:
Rows: 1: "googlee ggooogle google" 2: "googgle yahhoo msn" 3: "some other keywords"
I ask for best matches with "google yahoo" and mysql should give me only row 2.

Closest match in MySQL by few keywords

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.