web statisticsweb stats

Business Phone Systems

Previous Thread
Next Thread
Print Thread
Rate Thread
#251068 03/31/06 02:07 PM
Joined: Mar 2004
Posts: 188
Member
Member
Joined: Mar 2004
Posts: 188
Anybody any good with MySQL? I'm trying to figure out an SQL statement that will change all of the items in say an Item field that have the item Accessories:Partnumber. So it would be in the column Item and then there's a whole bunch of items with the name Accessories:5555 and Accessories:6666 and Accessories:7777 so...I want to take out the part of the Item "Accessories:" Is there a way to do that, or do I have to do each item?


Cheryl McLean
Communications Done Right
Atcom VoIP Phones
VoIP Demo

Best VoIP Phones Canada


Visit Atcom to get started with your new business VoIP phone system ASAP
Turn up is quick, painless, and can often be done same day.
Let us show you how to do VoIP right, resulting in crystal clear call quality and easy-to-use features that make everyone happy!
Proudly serving Canada from coast to coast.

#251069 04/14/06 05:20 AM
Joined: Jun 2005
Posts: 102
Member
Member
Offline
Joined: Jun 2005
Posts: 102
Not real sure that this is it but might find this helpful, please use this in a test or a backup :


UPDATE mytable SET myfield = REPLACE( myfield,' %Accessories:%','')

The '' at the end are actually 2 single quotes


Keep The Old Stuff Running
#251070 04/14/06 05:55 AM
Joined: Jun 2005
Posts: 102
Member
Member
Offline
Joined: Jun 2005
Posts: 102
Or maybe better yet :


UPDATE mytable SET myfield = REPLACE( myfield,' Accessories:%','')

PLEASE DO NOT TRY THESE ON SOMETHING THAT MIGHT GET HOSED......


Keep The Old Stuff Running

Moderated by  MooreTel 

Link Copied to Clipboard
Newest Topics
NEC SL1100 i IP address
by teleco - 06/13/25 05:18 PM
3x8 Memory capacitor
by John807 - 06/12/25 01:14 PM
Bizarre Paging Issue
by Toner - 06/10/25 01:31 PM
SL2100 licenses
by andyphones - 06/09/25 11:19 AM
Forum Statistics
Forums84
Topics94,548
Posts640,092
Members49,857
Most Online5,661
May 23rd, 2018
Newest Members
telli, CCTechProf, Pinnacle Rich, chris c755555, empire
49,857 Registered Users
Top Posters(30 Days)
Toner 7
hbiss 2
Who's Online Now
0 members (), 807 guests, and 30 robots.
Key: Admin, Global Mod, Mod
Contact Us | Sponsored by Atcom: One of the best VoIP Phone Canada Suppliers for your business telephone system!| Terms of Service

Sundance Communications is not affiliated with any of the above manufacturers. Sundance Phone System Forums - VOIP & Cloud Phone Help
©Copyright Sundance Communications 1998 - 2025
Powered by UBB.threads™ PHP Forum Software 8.0.0