Maybe you need it!!!

Wednesday, 26 February 2014

[MySQL] - Regular Expressions - How to check a decimal number

To check if the field value is a decimal number, you can use the following expresion

REGEXP '^[[:digit:]]+\\.{0,1}[[:digit:]]*$'

Example: 
select '3.222' REGEXP '^[[:digit:]]+\\.{0,1}[[:digit:]]*$' as prueba;
1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Search This Blog

Popular Posts

  • [WINDOWS 10] Error de Conexión wifi sin Internet, segura
  • [vTiger 6] How to change default fields on popup ListView
  • [vTiger 6] Updated: How to disable editing on details view
  • [vTiger 6] Multiple instances on one installation
  • How to repair a pendrive on read only mode
  • [MySQL] - Regular Expressions - How to check a decimal number
  • [vTiger 6] Change comments order
  • Problemas de conexión Wifi: Router Teldat Movistar vs PC antiguo
  • Helicóptero antiincendios recogiendo agua en el canal de Villabúrbula

Blog Archive

  • ►  2017 (1)
    • ►  January (1)
  • ►  2015 (1)
    • ►  February (1)
  • ▼  2014 (6)
    • ►  May (3)
    • ►  April (1)
    • ►  March (1)
    • ▼  February (1)
      • [MySQL] - Regular Expressions - How to check a dec...
  • ►  2009 (1)
    • ►  October (1)

Labels

IT (8) develop (4) vtiger6 (4) mysql (1) regexp (1)

Friends

  • Babuleando
Ethereal theme. Theme images by Storman. Powered by Blogger.