Vivid Lust Posted December 3, 2009 Share Posted December 3, 2009 Is there any way to remove all spaces in mySQL so: sp ace becomes space If someone could give me this query, I would be very greatfull, thanks lots. Quote Link to comment https://forums.phpfreaks.com/topic/183892-mysql-remove-all-spaces-urgent-last-thing-i-need/ Share on other sites More sharing options...
mikesta707 Posted December 3, 2009 Share Posted December 3, 2009 what do you mean in mysql? do you mean in a mysql query? surely str_replace() will suit your needs there. Can you explain your question a little more Quote Link to comment https://forums.phpfreaks.com/topic/183892-mysql-remove-all-spaces-urgent-last-thing-i-need/#findComment-970745 Share on other sites More sharing options...
Maq Posted December 3, 2009 Share Posted December 3, 2009 This should work. UPDATE [table_name] SET [column]=(REPLACE ([column], ' ', '')); Quote Link to comment https://forums.phpfreaks.com/topic/183892-mysql-remove-all-spaces-urgent-last-thing-i-need/#findComment-970749 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.