<div>
Try select * from table where CAST(field, INT) &lt;&nbsp;2
</div>


<div>
<div class="content wysiwyg-content">
I'm querying a database I don't have control over. There is a string field which holds numbers, NULL and ''. What do I need to do to compare the string field as a number<br />
<br />
Ex. I have the following values in the table<br />
NULL<br />
''<br />
'0'<br />
'1'<br />
'2'<br />
'11'<br />
<br />
I want to select * from table where field &lt;&nbsp;2<br />
<br />
It should only return 1 and 0 (I would also be OK with it treating NULL and '' as 0 and returning those), not the 11 or 2.
</div>
</div>


I'm querying a database I don't have control over. There is a string field which holds numbers, NULL and ''. What do I need to do to compare the string field as a number

Ex. I have the following values in the table
NULL
''
'0'
'1'
'2'
'11'

I want to select * from table where field < 2

It should only return 1 and 0 (I would also be OK with it treating NULL and '' as 0 and returning those), not the 11 or 2.

Try select * from table where CAST(field, INT) &amp;lt; 2

mySQL compare string as numeric

I&amp;#39;m querying a database I don&amp;#39;t have control over. There is a string field which holds numbers, NULL and &amp;#39;&amp;#39;. What do I need to do to compare the string field as a number

Ex. I have the following values in the table
NULL
&amp;#39;&amp;#39;
&amp;#39;0&amp;#39;
&amp;#39;1&amp;#39;
&amp;#39;2&amp;#39;
&amp;#39;11&amp;#39;

I want to select * from table where field &amp;lt; 2

It should only return 1 and 0 (I would also be OK with it treating NULL and &amp;#39;&amp;#39; as 0 and returning those), not the 11 or 2.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.