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
IplWin stands as a reliable and enthralling platform for Indian punters, offering a captivating blend…
Introduction In today's online age, consumers are constantly bombarded with information. They crave valuable content…
In today’s rapidly aging society, finding a living situation that provides older adults with both…
If you wish to purchase a Mac, then it is strongly suggested to consider purchasing…
Oil drilling is a complex process that involves several components, including the drilling bit. The…
Watches can be more than a fashion. They can be a symbol, especially in the…