/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

21 votes444 views6 answers
Wordpress do shortcode
PHP Wordpress
25 votes331 views6 answers
Laravel use cache
PHP
8 votes295 views1 answer
Artisan link public
PHP
1 vote381 views1 answer
Datediff in hour query builder laravel
PHP Laravel
1 vote321 views1 answer
Remove product (item) from WooCommerce checkout page using AJAX
PHP
0 vote319 views1 answer
E_notice in php
PHP
0 vote319 views1 answer
Change arabic number to english php
PHP
0 vote321 views1 answer
Laravel search and return record with pagination
PHP
0 vote318 views1 answer
Laravel error reporting code for view
PHP
1 vote351 views2 answers
How to install php dependencies
PHP

Share