SQL Statement to Fine Non Decimal in Mysql -


i have sql statement in mysql db find non decimal number decimal number. data this.

  table: products  productid 10.20 12.15 136.42  need results below.  productid 10 12 136   ideas? 

i suggest use floor () .

select floor(productid) table 

Comments

Popular posts from this blog

.htaccess - First slash is removed after domain when entering a webpage in the browser -

Socket.connect doesn't throw exception in Android -

SPSS keyboard combination alters encoding -