Remove a number form every element ina colum

[Wildhalf]

Hi

 

Anyone know the SQL i could use to remove a number (which is on the right hand side of string) from every entry in my table (wp_terms) in the name colum???

 

example 1: Dry Cleaning2

example 2: Travel2

 

I have over 700 to do so would be hard manually

 

thanks

[Wildhalf]

Sorted it out myself

 

used

 

UPDATE `TABLE_NAME` SET `COLLUM_NAME` = REPLACE(`COLLUM_NAME`, 'VALUE_TO_CHANGE', '')

[kickstart]

Hi

 

Is it always a single digit numeric, and does it apply to all rows?

 

If so then

 

UPDATE TableName
SET ColumnName = SUBSTR(ColumnName,1,LENGTH(ColumnName) -1)

 

All the best

 

Keith