jasonphd Posted May 28, 2009 Share Posted May 28, 2009 insert into t1(f1,f2,f3) select f1, f2, f3 from t2 I have code like the above. F2 is an email address that looks like '[email protected]'. What actually gets inserted is just 'bla'. Only stuff before the first "." gets inserted. I'm issuing the command via php's mysql_query function. Is there a way to make it ignore special characters? Am I doing something wrong? Link to comment https://forums.phpfreaks.com/topic/159964-solved-insert-select-statement-incorrect-for-email-addresses/ Share on other sites More sharing options...
fenway Posted June 2, 2009 Share Posted June 2, 2009 That sounds impossible... unless t1 doesn't have the same column types. Link to comment https://forums.phpfreaks.com/topic/159964-solved-insert-select-statement-incorrect-for-email-addresses/#findComment-847718 Share on other sites More sharing options...
jasonphd Posted June 2, 2009 Author Share Posted June 2, 2009 Yes, it is impossible. I misdiagnosed the issue. It was something completely different. Link to comment https://forums.phpfreaks.com/topic/159964-solved-insert-select-statement-incorrect-for-email-addresses/#findComment-847728 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.