Convert string to MYSQL integer

Question

What command can I use to convert string to integer in mysql? for example:

I am making the following list of tables:

SELECT mov . * , prod.produto, prod.unidade, prod.icms, prod.ipi, prod.codigo
FROM movimentacao AS mov, produtos AS prod
WHERE mov.Codigo = prod.codigo 

The field prod.codigo is with the value 0259 and the countryside mov.Codigo is with 259 and at the time of comparison they are not equal, I was wondering if you have any command that converts the value of the prod.codigo for whole to stay 259

Answer 1

Use CAST():

SELECT mov . * , prod.produto, prod.unidade, prod.icms, prod.ipi, cast(prod.codigo as unsigned integer)
FROM movimentacao AS mov, produtos AS prod
WHERE mov.Codigo = prod.codigo 

Source: http://dev.mysql.com/doc/refman/5.0/en/charset-convert.html

Answer 2

Just force a numeric operation on the string:

SELECT mov.* , prod.produto, prod.unidade, prod.icms, prod.ipi, cast(prod.codigo as unsigned integer)
FROM movimentacao AS mov, produtos AS prod
WHERE mov.Codigo = 0 + prod.codigo

Answer 3

That way if there is no typo

Function: Cast

SELECT mov.* , 
       prod.produto, 
       prod.unidade, 
       prod.icms, 
       prod.ipi, 
       prod.prodcodigo
FROM movimentacao AS mov, 
     (
        SELECT CAST(prod.codigo) as prodcodigo,
            prod.produto, 
            prod.unidade, 
            prod.icms, 
            prod.ipi
     ) AS prod
WHERE mov.Codigo = prod.prodcodigo

Obs: prod.codigo got prod.prodcodigo to differentiate from mov.codigo

References:

• Mysql - The world’s Most popular open source database

• 12.10 Cast Functions and Operators