<div>
if content_id is an integer then you can not search for a string '9G2Mi' you can only search for an integer
</div>


if content_id is an integer then you can not search for a string '9G2Mi' you can only search for an integer

<div>
Integer means full numbers, so your content_id column should have only numbers.
</div>


Integer means full numbers, so your content_id column should have only numbers.

<div>
if you wonder why this actually works in some places and not other, you likely are testing without safe mode enabled in which case mysql will silently convert the provided string to an integer ( and most likely return nothing ) but not complain either
</div>


if you wonder why this actually works in some places and not other, you likely are testing without safe mode enabled in which case mysql will silently convert the provided string to an integer ( and most likely return nothing ) but not complain either

<div>
<div class="content wysiwyg-content">
I am doing the following MySQL query and I get a result that I believe normally it should not occur. I am missing something or is a real MYSQL bug?<br />
<br />
SELECT * FROM content WHERE content_id='9G2Mi'<br />
<br />
Please see attached image.<br />
<br />
The column is Integer - content_id - int(11)
</div>
</div>


I am doing the following MySQL query and I get a result that I believe normally it should not occur. I am missing something or is a real MYSQL bug?

SELECT * FROM content WHERE content_id='9G2Mi'

Please see attached image.

The column is Integer - content_id - int(11)

Is this a MySQL bug or a normal behavior?

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.