How do I remove slashes during a select statement

Question

Please I am new. I am performing an insert select and I want to remove the slashes in a particular field say field b at the select portion of the query. eg. insert into mytable(a,b,c) select a, stripslashes(b),c from mysecondtable;

Please help.

Answer 1

Are you doint this with PHP? Then a simple $fieldB = strip_slashes($_POST['b']); should do. You should then use $fieldB in your query.

Answer 2

You can use MySQL String functions, e.g. replace.

Also consider sanitizing or preparing any input to the SELECT in the calling application before you execute the query.

Answer 3

use the SUBSTR function of mysql or do something like this:

"insert into table set value = " . stripslashes('whatever')

Answer 4

Hi Emma, you can use REPLACE like this:

insert into mytable(a,b,c) 
select a, REPLACE(b, '\\', '\') as b, c 
  from mysecondtable;

The REPLACE expression might have to be refined, but I hope this gets you started.