0

replace MySQL column value before matching

How to use REPLACE in mysql query with example

suppose you have a list of Spa Centers in your mysql table.and you want to search in your tables to get similier results that user searched for.if you are looking for a solution for this then this post is for you 😀

Table Structure

replace MySQL column value before matching

so here is a list of all centers in my center_name column and my user searched for O2 spa.As you can see in my table there are 2 centers with O2 Spa name.But one of them also including desh (-) in its name.so if i use mysql’s like then it will simply ignore my O2-Spa and will return only O2 SPA HOTEL HILTON.And definitelly i don’t want only 1 result just because a dash (-) is there 🙁 .Mates lets remove the dash 😀 here we go

we will use mysql’sREPLACE string function to replace column value before matching it to our user’s search string.MySQL REPLACE() replaces all the occurrences of a substring within a string.

Syntax :

REPLACE(str, find_string, replace_with)

Argument :

NameDescription
strA string or column name
find_stringA string which is present one or more times within the string str.
replace_withA string which will replace every time it finds find_string within str.

Mysql Query :

Result

REPLACE in mysql query result with example

Hope you find this post useful,If it is then please do share with your developer friends 🙂 Happy day

Leave a Reply

Your email address will not be published. Required fields are marked *