Hi,
Not that hard :)
Add a new field called Name2. Then just run a SQL to populate it:
It seems REPLACE does not let you do a replace using ^ as an anchor to the rule - so if you had something like:
"Something The Fool"
It would convert to:
"Something Fool"
If you do have that, lemme know and I'll knock up a simple script to do it for ya ;) (only a few lines of code)
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Not that hard :)
Add a new field called Name2. Then just run a SQL to populate it:
Code:
UPDATE glinks_Category SET Name2 = REPLACE(Name,"The ","");It seems REPLACE does not let you do a replace using ^ as an anchor to the rule - so if you had something like:
"Something The Fool"
It would convert to:
"Something Fool"
If you do have that, lemme know and I'll knock up a simple script to do it for ya ;) (only a few lines of code)
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!