Compare two numbers in MySQL.

[Triedge 12]

Currently I feel the need to make a table with certain numbers, players must put a PIN, the problem is that the saved in the MySQL database often is not the same number, add additional numbers.

It would be possible to make the MySQL make a comparison of the last 6 numbers?

 

Example:

Number in MysQL: 774485511697

Number in PIN: 511697

 

As the number 511697 is equal to the last number stored in the MySQL taking as true.

 

[mleo1 36]

RIGHT(774485511697,6) =  511697
SUBSTR(774485511697,-6) =  511697

or etc
 

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
 

Edited March 29, 2014 by mleo1

[dudemelo 3]

SUBSTRING(774485511697, -6) = 511697

Edited March 29, 2014 by dudemelo

[evilpuncker 503]

btw why not fix the script to add the correct count of numbers?