| Welcome to WebmasterWorld Guest from 22.214.171.124 |
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
|Accredited PayPal World Seller|
|Query to delete some characters from a column|
or how to remove parts of a string
| 1:33 pm on Nov 15, 2011 (gmt 0)|
I search for an answer but couldnīt find one that work.
I have a column on a table with thousands of lines with values like:
... and so on
And I need to delete everything after -v16-, including the "-v16-".
Is it possible to do that in phpMyAdmin?
| 1:59 pm on Nov 15, 2011 (gmt 0)|
see documentation for substring_index function
update your_table set your_field=substring_index(your_field,'-',2)
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved