<ul id="menu-primary-menu" class="amp-menu"><li id="menu-item-9" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-9 "><a href="https://www.websourceblog.com/category/wordpress/" class="dropdown-toggle" data-toggle="dropdown">WordPress</a></li> <li id="menu-item-102" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-102 "><a href="https://www.websourceblog.com/category/php/" class="dropdown-toggle" data-toggle="dropdown">PHP</a></li> <li id="menu-item-101" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-101 "><a href="https://www.websourceblog.com/category/magento/" class="dropdown-toggle" data-toggle="dropdown">Magento</a></li> <li id="menu-item-196" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-196 "><a href="https://www.websourceblog.com/category/drupal/" class="dropdown-toggle" data-toggle="dropdown">Drupal</a></li> <li id="menu-item-91" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-91 "><a href="https://www.websourceblog.com/category/seo/" class="dropdown-toggle" data-toggle="dropdown">SEO</a></li> <li id="menu-item-47" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-47 "><a href="https://www.websourceblog.com/category/photoshop/" class="dropdown-toggle" data-toggle="dropdown">Photoshop</a></li> </ul>

All Rights ReservedView Non-AMP Version

<ul id="menu-secondary-menu-1" class="amp-menu"><li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-308 "><a href="https://www.websourceblog.com/expertise/" class="dropdown-toggle" data-toggle="dropdown">Expertise – Full Stack Developer</a></li> <li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-178 "><a href="https://www.websourceblog.com/contact-us/" class="dropdown-toggle" data-toggle="dropdown">Contact Us</a></li> <li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-privacy-policy menu-item-1580 "><a href="https://www.websourceblog.com/privacy-policy/" class="dropdown-toggle" data-toggle="dropdown">Privacy Policy</a></li> <li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-1606 link-menu"><a href="#"on="tap:AMP.setState({ offcanvas_menu: false })" role="button " tabindex="0" class="dropdown-toggle" data-toggle="dropdown">Hosting Services</a> <input type="checkbox" id="drop-3"><label for="drop-3" class="toggle"></label><ul class="sub-menu"> <li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1607 "><a href="https://www.websourceblog.com/dreamhost-best-hosting-provider/">DreamHost: A Complete Web Hosting Solution</a></li> <li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1614 "><a href="https://www.websourceblog.com/digitalocean-a-gateway-to-cloud-simplicity/">DigitalOcean: A Gateway to Cloud Simplicity</a></li> </ul> </li> </ul>

Misc.

REPLACE function in mySql.

MySql database has very simple and easy to use string function REPLACE() that is used to find any string and replace it with new string. This is very useful when we required replacing any content in multiple rows. It performs a case-sensitive match when searching for from_str. It has following syntax.

REPLACE(text_string,from_string,to_string)

Details:

text_string: The string in which you want to find and replace.
from_string: The string that you want to replace.
to_string: The string that you want after replace.

Examples:

Update Table set Field = REPLACE(field_name, ‘find string’,’replace string’);
You can read more about MySql functions on mysql function references.

Facebook

Twitter

Tumblr

websourceblog

ReactJs, NodeJs, Amazon Web Services, Symfony, Laravel, CodeIgniter, Zend Framework, WordPress, Drupal, Magento, Angular