/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

8 votes242 views3 answers
Laravel log query for model
PHP Laravel
0 vote224 views1 answer
Laravel list unique indexes
PHP Laravel
0 vote188 views1 answer
Convert stdclass to json in php
PHP
7 votes194 views1 answer
Passport generate key
PHP
0 vote220 views1 answer
Wordpress plugin public page
PHP Wordpress
0 vote236 views1 answer
Enum artisan codwe
PHP
2 votes204 views1 answer
Laravel project editor
PHP
6 votes220 views3 answers
Laravel 8 with jetstream
PHP Laravel
-1 vote162 views2 answers
Laravel pagination keep query string
PHP
11 votes211 views6 answers
Redirect route with parameters laravel
PHP Laravel

Share