Results 1 to 3 of 3
  1. #1
    Full Member
    Join Date
    January 18th, 2005
    Posts
    462
    Hi everyone!

    Does anyone know a command or anything in PHPMyAdmin that allows you to remove quotes from a field in my database? It's driving me nuts!

    Core

    "So it's a profit thing..." - Steve Martin

  2. #2
    ABW Ambassador cditty's Avatar
    Join Date
    January 18th, 2005
    Location
    Memphis TN
    Posts
    1,434
    You can't replace the quotes unless you run the file through some kind of script. You can comment them out by using a / .

    Try adding that to your query in phpmyadmin. Should fix your problem. If / doesn't work, try \.

    Chris

    ----------------------------
    Scriptsforyoursite.com - Featuring datafeed import scripts for Art.com, Coldwater Creek, Mondera.com, OverStock.com, TigerDirect and more.....

  3. #3
    Newbie
    Join Date
    January 18th, 2005
    Posts
    3
    Assuming you have unwanted quotes (") in your field, the following query should work:

    UPDATE [table] SET [field] = REPLACE([field], '"', '');

    Of course, you must replace the [table] and [field] above with the values that match your database schema.

    Hope that helps,
    Jeremiah

  4. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. So i've got the datafeed into mysql database..
    By chillini in forum Programming / Datafeeds / Tools
    Replies: 10
    Last Post: December 2nd, 2008, 02:06 PM
  2. Database Replication with mySQL
    By Snib in forum Programming / Datafeeds / Tools
    Replies: 10
    Last Post: September 8th, 2006, 01:24 AM
  3. Removing HTML from Large Database Files
    By jdsguam in forum Programming / Datafeeds / Tools
    Replies: 10
    Last Post: August 10th, 2006, 09:29 AM
  4. How can I use buyitbomb with Mysql database?
    By Amavisca in forum Programming / Datafeeds / Tools
    Replies: 0
    Last Post: July 6th, 2005, 06:43 AM
  5. MySQL database - Can I...
    By ~Michelle in forum Programming / Datafeeds / Tools
    Replies: 2
    Last Post: March 26th, 2004, 01:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •