sql query to strip all non a-z/0-1 characters?

[acctman]

hi can someone help me with a sql query that will strip all non A-z and 0-1 characters from a field? I've already added the html escape string to all new sql inserts i just need to remove all the current.

 

table: MemberInfo

Field: m_aboutme

[KPH71]

I would just use PHP for this - I don't know of a way to do this in mysql.

 

You could use something like str_replace() in PHP. It would be useful to know what kind of data you are expecting...

[premiso]

You could use something like str_replace() in PHP.

 

preg_replace as he wants a specific, but unknown number of item(s), which I doubt str_replace would suffice for his need.

 

[acctman]

You could use something like str_replace() in PHP.

 

preg_replace as he wants a specific, but unknown number of item(s), which I doubt str_replace would suffice for his need.

 

 

do you have an example of how this sql query would work?

[premiso]

It would not be done in SQL, it would be done before  the value is entered into SQL or upon retrieving the value from SQL.

 

<?php
$string = "stripallalpha%$%2324numerics";
$string = preg_replace("~([a-z0-9])~i", "", $string);
echo $string;
die();
?>

 

Should leave you with %$%.