/PHP/Mysql replace a character in a string

Mysql replace a character in a string

Mysql replace text

UPDATE
    table_name
SET
    column_name = REPLACE(column_name, 'text to find', 'text to replace with')
WHERE
    column_name LIKE '%text to find%';

9

Mysql replace a character in a string

UPDATE users SET first_name = REPLACE (first_name, 'search', 'replace_with') where id > 0;

8

Similar codes

0 vote96 views1 answer
Yii2 label of ActiveField
PHP
0 vote88 views1 answer
Encryption and decryption in php example
PHP
1 vote112 views3 answers
Get all post meta
PHP
4 votes92 views3 answers
Laravel execute command from terminal
PHP
0 vote97 views1 answer
Slidepay
PHP
3 votes112 views2 answers
How to redirect a particular user role to a page after login laravel
PHP Laravel
0 vote118 views2 answers
Upload video in laravel
PHP Laravel
0 vote128 views2 answers
Fetch data based on month and year in laravel
PHP Laravel
5 votes123 views5 answers
Laravel get all request parameters
PHP Laravel
2 votes97 views2 answers
Php test page
PHP

Share