Sometimes we need to add demo text in a website for checking whether it working fine or somewhere we test website with demo text. So on this case unwanted text inserted into database and you need to remove it. So, we can update fields with random sentence in this case.
For example the fields value will be different.
Just like below:
Suspendisse accumsan lacinia nisi vel posuere. Nam et ante pretium at dapibus. Suspendisse accumsan lacinia nisi vel posuere. Nam et ante pretium at dapibus.
But you don’t need to remove it just update the fields with random text and your text will looks as collection of words.
Read Also: Update from one table to another with condition in MySQL
UPDATE `tbl_demo` set `field` =
concat(
(substring("ABCDEFGHIJKLMNOPQRSTUVWXYZ", rand()*36+1, 2)),
(substring("abcdefghijklmnopqrstuvwxyz", rand()*36+1, 10)),
(" "),
(substring("abcdefghijklmnopqrstuvwxyz", rand()*36+1, 8)),
(" "),
(substring("abcdefghijklmnopqrstuvwxyz", rand()*36+1, 9)),
(" "),
(substring("abcdefghijklmnopqrstuvwxyz", rand()*36+1, 10)),
(" "),
(substring("abcdefghijklmnopqrstuvwxyz", rand()*36+1, 7)),
(" "),
(substring("abcdefghijklmnopqrstuvwxyz", rand()*36+1, 10)))
where `id` = 1 Online trading has brought ease of trading, better security protocols, and fast trade executions; however,…
Very few brands suffer from a product issue. It's a conversion issue. People enter DMart,…
The onboarding process of the retailer, distributor, or partner may soon become problematic if there…
Many of the states in the United States of America allow the use of medical…
Did you know that every time you browse this website or any other, you leave…
Online casino has gained immense popularity with the rise of online casinos. Platforms like GameZone…