[Skip to main content](#vessel-content) # need to remove some stuff from description ## - **[cctaco](/forum/user/14097-cctaco "View cctaco's Profile")** - [![cctaco's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-07-21.gif)](/forum/user/14097-cctaco "View cctaco's Profile") Topic Author - [ Offline](/forum/user/14097-cctaco) - www.ifixmachines.com Less More - Posts: 33 - Thank you received: 2 - - - - [](http://www.ifixmachines.com) - 5 years 8 months ago [\#329374](#329374) by [cctaco](/forum/user/14097-cctaco "View cctaco's Profile") *[need to remove some stuff from description](/forum/44-mass-actions/901890-need-to-remove-some-stuff-from-description#329374 "-- url of the page with the problem -- : www.ifixmachines.com -- HikaShop version -- : 4.4.0 -- Joomla version -- : 3.9.24 -- PHP version -- : 7.4.14 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : none I have a site from 2009 that I imported into hikashop I'd like to use mass action to remove a line of code from the description if is found. this is the code that is in about 1/2 of my product descrptions. Can you help me code the proper query string and action to remove it.")* was created by *[cctaco](/forum/user/14097-cctaco "View cctaco's Profile")* -- url of the page with the problem -- : [ www.ifixmachines.com](http://www.ifixmachines.com) -- HikaShop version -- : 4.4.0 -- Joomla version -- : 3.9.24 -- PHP version -- : 7.4.14 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : none I have a site from 2009 that I imported into hikashop I'd like to use mass action to remove a line of code from the description if is found. this is the code that is in about 1/2 of my product descrptions. <hr id="system-readmore" /> Can you help me code the proper query string and action to remove it. --- HikaShop Business 2.6.0 PHP Version 5.6.16 Web Server Apache Joomla! 3.4.8 Stable \[ Ember \] 24-December-2015 19:30 GMT Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDE4OTAtbmVlZC10by1yZW1vdmUtc29tZS1zdHVmZi1mcm9tLWRlc2NyaXB0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 5 years 8 months ago [\#329379](#329379) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[need to remove some stuff from description](/forum/44-mass-actions/901890-need-to-remove-some-stuff-from-description#329379 "-- url of the page with the problem -- : www.ifixmachines.com -- HikaShop version -- : 4.4.0 -- Joomla version -- : 3.9.24 -- PHP version -- : 7.4.14 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : none I have a site from 2009 that I imported into hikashop I'd like to use mass action to remove a line of code from the description if is found. this is the code that is in about 1/2 of my product descrptions. Can you help me code the proper query string and action to remove it.")* Hi, You want to have an action "update the values" on the product_description column with the type "operation" and the value: Code: REPLACE('<hr id="system-readmore" />', '',product.product_description) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDE4OTAtbmVlZC10by1yZW1vdmUtc29tZS1zdHVmZi1mcm9tLWRlc2NyaXB0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[cctaco](/forum/user/14097-cctaco "View cctaco's Profile")** - [![cctaco's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-07-21.gif)](/forum/user/14097-cctaco "View cctaco's Profile") Topic Author - [ Offline](/forum/user/14097-cctaco) - www.ifixmachines.com Less More - Posts: 33 - Thank you received: 2 - - - - [](http://www.ifixmachines.com) - 5 years 8 months ago [\#329592](#329592) by [cctaco](/forum/user/14097-cctaco "View cctaco's Profile") Replied by *[cctaco](/forum/user/14097-cctaco "View cctaco's Profile")* on topic *[need to remove some stuff from description](/forum/44-mass-actions/901890-need-to-remove-some-stuff-from-description#329592 "-- url of the page with the problem -- : www.ifixmachines.com -- HikaShop version -- : 4.4.0 -- Joomla version -- : 3.9.24 -- PHP version -- : 7.4.14 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : none I have a site from 2009 that I imported into hikashop I'd like to use mass action to remove a line of code from the description if is found. this is the code that is in about 1/2 of my product descrptions. Can you help me code the proper query string and action to remove it.")* It removes the complete description if the <hr id="system-readmore" /> is found in the description. here is a link to the mass action page of the operation. [ nimb.ws/HyYhkN](https://nimb.ws/HyYhkN) --- HikaShop Business 2.6.0 PHP Version 5.6.16 Web Server Apache Joomla! 3.4.8 Stable \[ Ember \] 24-December-2015 19:30 GMT Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDE4OTAtbmVlZC10by1yZW1vdmUtc29tZS1zdHVmZi1mcm9tLWRlc2NyaXB0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 5 years 8 months ago [\#329599](#329599) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[need to remove some stuff from description](/forum/44-mass-actions/901890-need-to-remove-some-stuff-from-description#329599 "-- url of the page with the problem -- : www.ifixmachines.com -- HikaShop version -- : 4.4.0 -- Joomla version -- : 3.9.24 -- PHP version -- : 7.4.14 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : none I have a site from 2009 that I imported into hikashop I'd like to use mass action to remove a line of code from the description if is found. this is the code that is in about 1/2 of my product descrptions. Can you help me code the proper query string and action to remove it.")* Hi, My bad, I put the parameters in the wrong order: [ www.w3resource.com/mysql/string-function...replace-function.php](https://www.w3resource.com/mysql/string-functions/mysql-replace-function.php) it should be: REPLACE(product.product_description,'<hr id="system-readmore" />', '') Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDE4OTAtbmVlZC10by1yZW1vdmUtc29tZS1zdHVmZi1mcm9tLWRlc2NyaXB0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.121 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)