mysql replace in select query

mysql replace in select query
 

select * from tablename where replace(fieldname,'findvalue','replacevalue') = '$value' 

Here before check the condition to replace the value from field value and then execute.