/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

2 votes151 views2 answers
How to use vue 3 in laravel 8
PHP Laravel
0 vote146 views1 answer
Access to this resource on the server is denied laravel
PHP Laravel
30 votes127 views6 answers
Laravel migration column types
PHP
33 votes142 views6 answers
How to run a specific migration in laravel
PHP Laravel
0 vote145 views7 answers
Php
PHP
0 vote164 views1 answer
How to add page link in laravel
PHP Laravel
0 vote140 views1 answer
Deactivate auto update wordpress plugins
PHP
0 vote129 views1 answer
Php date modify plus 1 day
PHP
1 vote158 views1 answer
Get request data in observer laravel
PHP Laravel
0 vote135 views1 answer
Php how to make sure user doesn't submit
PHP

Share