How do I check to see if a value is an integer in MySQL?

by

I’ll assume you want to check a string value. One nice way is the REGEXP operator, matching the string to a regular expression. Simply do

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

this is reasonably fast. If your field is numeric, just test for

ceil(field) = field

instead.

More Related Contents:

  1. How to get a ranking result for special record in mysql [closed]
  2. SQL Query needed for fetch value from Two identical table but not fully identical table
  3. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  4. How to reset AUTO_INCREMENT in MySQL
  5. MySQL: Insert record if not exists in table [duplicate]
  6. MySQL Query GROUP BY day / month / year
  7. How do I change the data type for a column in MySQL?
  8. How do I use on delete cascade in mysql?
  9. Adding a leading zero to some values in column in MySQL
  10. How to access remote server with local phpMyAdmin client?
  11. How to copy data from one table to another new table in MySQL?
  12. How to connect mysql workbench to running mysql inside docker?
  13. Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’
  14. Calculate the time difference between of two rows
  15. MySQL/Writing file error (Errcode 28)
  16. MySQL Group By and Sum total value of other column
  17. MySQL : Multiple row as comma separated single row
  18. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  19. Export a MySQL Database to SQLite Database
  20. Return a default value if single row is not found
  21. How to find out the MySQL root password
  22. SQL search multiple values in same field
  23. Removing duplicates with unique index
  24. MySQL – Select the last inserted row easiest way
  25. Getting number of rows inserted for ON DUPLICATE KEY UPDATE multiple insert?
  26. ALTER table – adding AUTOINCREMENT in MySQL
  27. Does MySQL foreign_key_checks affect the entire database?
  28. MySQL Recursive get all child from parent
  29. is it possible to call a sql script from a stored procedure in another sql script?
  30. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)

Leave a Comment