Data Cleanup

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
jwalsh
Forum Contributor
Posts: 202
Joined: Sat Jan 03, 2004 4:55 pm
Location: Cleveland, OH

Data Cleanup

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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

User avatar
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)
Post Reply