/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 vote124 views1 answer
Strrev php
PHP
1 vote101 views1 answer
Laravel command parameter optional
PHP
0 vote88 views1 answer
Laravel download file from storage with progress bar
PHP Laravel
0 vote118 views1 answer
Comment installer laravel avec docker
PHP
12 votes107 views5 answers
Php number_format
PHP
5 votes122 views3 answers
Return view controller laravel
PHP Laravel
6 votes106 views3 answers
Disable foreign key laravel
PHP
3 votes99 views1 answer
Laravel check if array is empty
PHP
5 votes106 views5 answers
Table drop foreign php laravel
PHP
15 votes122 views4 answers
Php delete file
PHP

Share