mysql replace in select query

by Francis 2014-06-27 10:19:03

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.

 
1141
like
0
dislike
0
mail
flag

You must LOGIN to add comments