Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
jwalsh
- Forum Contributor
- Posts: 202
- Joined: Sat Jan 03, 2004 4:55 pm
- Location: Cleveland, OH
Post
by jwalsh »
Hi,
Trying to clean up some data from a data entry clerk, is there a way to fix the following 2 problems using SQL only?
1) Remove trailing whitespace from all entries?
2) Remove Hyphens (-) from all entries?
Josh
-
feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
Post
by feyd »
-
jwalsh
- Forum Contributor
- Posts: 202
- Joined: Sat Jan 03, 2004 4:55 pm
- Location: Cleveland, OH
Post
by jwalsh »
Thanks.
FYI.. RTRIM() (duh, just didn't know mysql had that function) and REPLACE() (again, didn't know mysql had it)