/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 vote258 views1 answer
Wordpress add new page programmatically
PHP Wordpress
2 votes276 views1 answer
Showing database table in php
PHP
4 votes199 views1 answer
Limit offset array php
PHP
0 vote231 views1 answer
Wordpress display post categories
PHP
0 vote188 views3 answers
Connect php in sql server
PHP
0 vote174 views1 answer
How to fetch google reviews and data in php URl
PHP
0 vote228 views3 answers
Upload multiple files in codeigniter
PHP CodeIgniter
0 vote160 views1 answer
What is carriage return in php
PHP
0 vote167 views1 answer
Composer don't load class
PHP
0 vote240 views1 answer
$age = 20; print ($age >= 18) ? "Adult" : "Not Adult";
PHP

Share