I have query like this

$where = $where." CAST({$field} AS TEXT) = '{$value_i}' AND ";

$a[] = "CAST({$field} AS TEXT) ~* '{$value_i}'";

if I excecute on postgres it's ok nevermind and if i excecute on mysql error in CAST $field=text, how to change into query on mysql?

thanks b4.