Convert a string to a tinyint

[Neske]

Hello,

Is it possible to convert a string to a tinyint?
Normally you would have this function: CAST(SUBSTRING(ip, 1, p1 - 1 ) AS tinyint) But this doesn't work in mysql.

Thx