Search and Repalce - MySQL
When I first started building mys computer components website I was totally new to programming - I knew a little HTML but that was it.
Thankfully on the Internet there are a few helpful people who are willing to share their skill of PHP and MySQL.
You can use this code in phpmyadmin or any other database manager
UPDATE table name SET Table Field = replace(table field,"string to find","string to replace")
On of the things that I found really helpful was how to search for a specific string within a database and replace that string. There are hundreds of reasons that you may wish to do this but an example is this:
Say within your site you are optimising you product pages and you want to ensure you internal linking structure points your users to the correct pages. You could search for every instance of ” computer components ” and make it link to the relevant page. This is great fro SEO purposes.
Of course there are other reasons why you may use it, perhaps you want to add a style or class to every table. This is made easy with search and replace.
