/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 vote123 views1 answer
Php echo and array to consle
PHP
0 vote138 views4 answers
Image Upload in Laravel
PHP
0 vote128 views1 answer
How convert the string to int in laravel function event
PHP
1 vote179 views3 answers
Laravel validate change password
PHP Laravel
2 votes129 views2 answers
Laravel show table columns
PHP Laravel
6 votes145 views1 answer
Route params link laravel
PHP Laravel
1 vote180 views1 answer
Datediff in hour query builder laravel
PHP
0 vote127 views1 answer
Contact form dropdown from post
PHP
8 votes124 views1 answer
How to list out routes
PHP
0 vote126 views1 answer
Wp wc php use comma separated thousands
PHP

Share