How Can I Verify if a Value is an Integer in MySQL?

Verifying Integers in MySQL

Determining the integer nature of a value in MySQL can be achieved with various approaches.

Using REGEXP Operator:

For checking string values, the REGEXP operator provides a robust solution. It matches the string against a regular expression, as demonstrated below:

select field from table where field REGEXP '^-?[0-9]+$';

This expression ensures that the string matches a non-negative integer or a negative integer with an optional leading hyphen.

Using ceil() Function:

If the field in question is numeric, a simpler method involves comparing it with its ceiling value:

ceil(field) = field

The ceil() function rounds the value up to the nearest integer. If the original value is an integer, it will remain unchanged, resulting in a true evaluation.

The above is the detailed content of How Can I Verify if a Value is an Integer in MySQL?. For more information, please follow other related articles on the PHP Chinese website!