/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

1 vote175 views1 answer
Laravel search data relationship
PHP
1 vote188 views1 answer
How to store an image in laravel directly from url
PHP Laravel
1 vote154 views1 answer
Get start of month end of month carbon
PHP
7 votes175 views3 answers
How to remove public from url in laravel 8
PHP
4 votes179 views2 answers
Pass parameter to view laravel
PHP
8 votes159 views1 answer
Storage image not showing in laravel
PHP
0 vote201 views1 answer
Laravel validation if another record is not deleted / not null
PHP Laravel
0 vote171 views1 answer
Get chmod of directory php
PHP
1 vote196 views1 answer
Php include once inside a function?
PHP
0 vote167 views1 answer
Php insert char before each letter using regex
PHP

Share