Update First Few Letters of Field

[jnull]

I am trying to create an sql that will go through my entire database that will remove the first few letters form the data in field, for example:

The field I want to update must have data that matches these first seven characters, "[b]About: [/b]", thus the data "[b]About: This Title[/b]" when updated should result with "[b]This Title[/b]" as the data.

Any help is greatly appreciated!  ::)

[obsidian]

It sounds like you just need to use a SUBSTRING() function within your SQL statement. Look in the MySQL manual at [url=http://dev.mysql.com/doc/refman/5.0/en/string-functions.html]String Functions[/url], specifically SUBSTRING(), and see if this helps.