MySQL – Anup Saund

Problem

Today, I wanted to strip slashes from a comment field using SQL (INSTEAD of using php stripslashes).

Why you ask?

I was working on an application which had not considered stripslashes for formatting output.

So I had a look and realised. Do I change 40,000 lines of code to add Stripslashes, or 1 line at the SQL select statement?

OK, slight exaggeration, but you get what I mean.

Solution

MySQL

Select
Replace(field_name, '\', '') as stripped_field
from
table;

Oracle

Select
Replace(field_name, '', '') as stripped_field
from
table;

PHP EXTRA

If using in PHP add an extra backslash like this;

// strip slashes as part of the SQL select statement
$sql = "Select Replace(field_name, '\', '') as stripped_field from table";

Please get in touch if you know of an easier way to do this, for example, Oracle Functions, or MySQL functions.

Many thanks and happy coding.

Tag: MySQL