How to get all image tags from an html - php code
I wanted to fetch all image tags from a big html, and wanted to perform some…
April 25, 2020
In a mysql table, I wanted to replace the hostname of the image URLs. And, it will be an update statement which will update all such records.
update `TABLE_NAME` set COLUMN_NAME = REPLACE (COLUMN_NAME, 'STRING_TO_SEARCH',
'STRING_TO_REPLACE_WITH') WHERE COLUMN_NAME like '%STRING_TO_SEARCH%';
In above query:
Note that in above query, where clause is suppose to filter out the target set of strings on which you want to work upon.
Now, if you notice that since REPLACE function will anyway has to do the search operation, what is the need of where clause. In reality, it is actually slowing down the system. Its not optimized. You can simply remove the where clause, and do something like:
update `TABLE_NAME` set COLUMN_NAME = REPLACE (COLUMN_NAME, 'STRING_TO_SEARCH',
'STRING_TO_REPLACE_WITH')
I wanted to fetch all image tags from a big html, and wanted to perform some…
This library is ES6, promise compatible. Or, in your package.json file, include…
Pylint is an excellent tool to have good quality code. This post is not about…
Introduction This post is about syncing your mongodo database data to…
I have been using drupal 7 from a long time, and setting up a dev environment…
Listing down the commonly used Elastic Search queries. You can get search…
Introduction This post has the complete code to send email through smtp server…
Introduction In a normal email sending code from python, I’m getting following…
Introduction In one of my app, I was using to talk to . I have used some event…
Introduction So you have a Django project, and want to run it using docker image…
Introduction It is very important to introduce few process so that your code and…
Introduction In this post, we will see a sample Jenkin Pipeline Groovy script…