Total digit check in Mysql

Asked

Viewed 27 times

0

Well, I need to select values formed by a total of 5 digits that start with "1" and end with "0". In the table, this attribute is of the decimal type. How can I perform this SELECT?

mysql sql

1 answer

2


You’d do it this way:

 SELECT * from minha_tabela where meu_campo between 10000 and 19999 and mod(meu_campo ,10) = 0

  • It could also be: SELECT * from my_table Where (my_field DIV 1000 = 1) and mod(my_field ,10) = 0;

Browser other questions tagged mysql sql

You are not signed in. Login or sign up in order to post.