SQL Query - GoFuckYourself.com

OptMediaJohn · 06-09-2005, 05:05 PM

Anyone good at SQL here?

I am trying to make a query that replaces a tab in a column after every entry in that column. I started using trim(), but I don't think I know how to use it corrrectly.

Here is what I have so far:

Select fullname_ from members_ and TRIM(BOTH ' ' members_);

What am i doing wrong?

cyber_ninja · 06-09-2005, 05:07 PM

dont do it

OptMediaJohn · 06-09-2005, 05:08 PM

Don't do it? Why? It has to be done...

woj · 06-09-2005, 05:10 PM

can you try explaining again what you are trying to do?

OptMediaJohn · 06-09-2005, 05:12 PM

Ok, I have a table members_ with a column fullname_ . The column fullname_ has a tab after every name (caused from the import of this table into this database). I want to remove this tab after every name in that column. Someone pointed me to TRIM, however I don't think I am doing that so well.

Does that make sense?

woj · 06-09-2005, 05:16 PM

make a backup of the table,
and then try something like this perhaps?
UPDATE members_ SET fullname_=TRIM(fullname_)

If you are still having problems you can hit me up on icq:33375924

OptMediaJohn · 06-09-2005, 05:34 PM

Big thanks to WOJ on this, looks like its running perfectly!

Thanks again!!

V_RocKs · 06-10-2005, 12:03 AM

WOJ gives advice? WOW!

Also, you can TEST it first by doing this,

SELECT TRIM(fullname_) from members_ SET

06-09-2005, 05:05 PM	#1
OptMediaJohn Registered User Join Date: May 2003 Posts: 11	SQL Query Anyone good at SQL here? I am trying to make a query that replaces a tab in a column after every entry in that column. I started using trim(), but I don't think I know how to use it corrrectly. Here is what I have so far: Select fullname_ from members_ and TRIM(BOTH ' ' members_); What am i doing wrong?

06-09-2005, 05:10 PM	#4
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	can you try explaining again what you are trying to do? __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

06-09-2005, 05:16 PM	#6
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	make a backup of the table, and then try something like this perhaps? UPDATE members_ SET fullname_=TRIM(fullname_) If you are still having problems you can hit me up on icq:33375924 __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

06-09-2005, 05:07 PM	#2
cyber_ninja Twerk That Ass Industry Role: Join Date: Jul 2001 Location: Lincoln, California Posts: 2,197	dont do it

06-09-2005, 05:08 PM	#3
OptMediaJohn Registered User Join Date: May 2003 Posts: 11	Don't do it? Why? It has to be done...

06-09-2005, 05:12 PM	#5
OptMediaJohn Registered User Join Date: May 2003 Posts: 11	Ok, I have a table members_ with a column fullname_ . The column fullname_ has a tab after every name (caused from the import of this table into this database). I want to remove this tab after every name in that column. Someone pointed me to TRIM, however I don't think I am doing that so well. Does that make sense?

06-09-2005, 05:34 PM	#7
OptMediaJohn Registered User Join Date: May 2003 Posts: 11	Big thanks to WOJ on this, looks like its running perfectly! Thanks again!!

06-10-2005, 12:03 AM	#8
V_RocKs Damn Right I Kiss Ass! Industry Role: Join Date: Dec 2003 Location: Cowtown, USA Posts: 32,409	WOJ gives advice? WOW! Also, you can TEST it first by doing this, SELECT TRIM(fullname_) from members_ SET