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 'bla.bla.bla@bla.com'. 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? Quote 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. Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.