MYSQL REPLACE string content with field value

Question

How can I REPLACE a string value with a other field content?

SELECT REPLACE(html_input,'!value',field_value) FROM table

Value of html_input is <input type='text' value='!value'>

Value of field_value is test

Expected result:

<input type='text' value='test'>

• McNets: Please tag you MySQL version.
• Spiderpoison: For any version
• Akina: It does not matter is any parameter a literal or a field name.
• Spiderpoison: Using a field does not work, returns a null field.
• Akina: Do not use IF() - there is COALESCE(field_value, '').

Answer 1

String literals must be enclosed by quotes '.

Quote symbols within a literal must be quoted by slash as \'.

SELECT REPLACE(html_input,'!value',field_value) 
FROM table
/* WHERE html_input = '<input type=\'text\' value=\'!value\'>'
 AND field_value = 'test';
*/

• Spiderpoison: I had chosen words that confused the question and it was edited in the wrong way causing confusion. I reworded the question! Thank you
• Akina: @user2175345 Your edition makes WHERE clause unnesessary. I'll comment it... Done.
• Spiderpoison: This is not a query with WHERE. Is a replace in a string by a value of a field. See again