Mysql update fields with random sentence

mysql

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

Example of Mysql update fields with random sentence:

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

Leave a Reply

Your email address will not be published. Required fields are marked *