/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 vote107 views1 answer
Laravel withValidator
PHP
1 vote138 views1 answer
Wordpress print all categories
PHP
1 vote107 views2 answers
Laravel check if object is empty
PHP
0 vote105 views1 answer
Php get object josn
PHP
4 votes145 views5 answers
Laravel with and where
PHP Laravel
18 votes120 views6 answers
Set timezone in php
PHP
1 vote114 views2 answers
Php strtotime plus 1 day
PHP
3 votes96 views2 answers
In arrray php
PHP
0 vote106 views1 answer
Make bot in php
PHP
17 votes144 views3 answers
Laravel order by desc
PHP Laravel

Share