Compare two numbers in MySQL.

[Triedge]

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.

 

[dudemelo]

SUBSTRING(774485511697, -6) = 511697

 

[mleo1]

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

or etc
 

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

 

[evilpuncker]

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