<div>
The match relevance is returned as a positive floating point number, or 0 for no similarity. It must be deciding there is a small similarity somehow! Try this:<br />
<br />
SELECT * , MATCH(titulo, descripcion) AGAINST ('280394829038402938409283<wbr />4034092402<wbr />40849' &nbsp;IN BOOLEAN MODE) as coincidencia from preguntas order by coincidencia DESC 
</div>


The match relevance is returned as a positive floating point number, or 0 for no similarity. It must be deciding there is a small similarity somehow! Try this:

SELECT * , MATCH(titulo, descripcion) AGAINST ('280394829038402938409283403409240240849'  IN BOOLEAN MODE) as coincidencia from preguntas order by coincidencia DESC

<div>
mmh, not really working for me, all I get is 0 in coincidencia even in keywords that exist...
</div>


mmh, not really working for me, all I get is 0 in coincidencia even in keywords that exist...

<div>
<div class="content wysiwyg-content">
Hello, I have a litle query that I am using to search inside a database, I have a fulltext index for the fields &quot;titulo &amp;&nbsp;descripcion&quot;, and the query works... the problem comes when I put something that doesn't exist in the database (like the search I have in the query &quot;2803948290384029384092834<wbr />0340924024<wbr />0849&quot;) this shouldn't give results but the problem is that it keeps giving me results... is there something I am doing wrong?<br />
<br />
Thank's<br />
<br />

<blockquote>
SELECT * , MATCH(titulo, descripcion) AGAINST ('280394829038402938409283<wbr />4034092402<wbr />40849') as coincidencia from preguntas order by coincidencia DESC 
</blockquote>
</div>
</div>


Hello, I have a litle query that I am using to search inside a database, I have a fulltext index for the fields "titulo & descripcion", and the query works... the problem comes when I put something that doesn't exist in the database (like the search I have in the query "280394829038402938409283403409240240849") this shouldn't give results but the problem is that it keeps giving me results... is there something I am doing wrong?

Thank's

SELECT * , MATCH(titulo, descripcion) AGAINST ('280394829038402938409283403409240240849') as coincidencia from preguntas order by coincidencia DESC 

Mysql match() againts() giving some problems to me?

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.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.