Not signed in (Sign In)

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.


Archive: Sql query to remove string...

Bottom of Page

1 to 2 of 2

  1.  
    • CommentAuthorjustnajm
    • CommentTimeDec 30th 2006
     
    Hello Friends,

    I have a table name 'products' and a column 'images' having values in format like 'products/SIB01108.JPG'. I want, values in this column in the format 'SIB01108.JPG' only that is I want to remove 'products/' string from all values at once.

    I uses mysql database. Plase tell me that is there any sql query which can do this task. I have more than 600 entries in table and cant change each value sapatately.....

    It is very urgent please help me out.
    • CommentAuthorjiosis
    • CommentTimeJan 30th 2007
     
    Justnajm please let me know if your found your answer as I really need such a script !
    The problem is that I always use php programming for such complex queries and it will increase the server load but if there is any solution to do it using mysql query that would be great.

    Thanks

1 to 2 of 2

  1.