issue in full text search using with replace.
Hello Team,
I have 2 mysql query
1 select name from student where MATCH (name) AGAINST ('+gopal' IN BOOLEAN MODE)
2 select replace(replace(replace(replace(replace(replace(replace(replace( name,":",''),";",""),",",""),".",""),"_",""),"'",""),"/",""),"-","")
from student
i want it combine this 2 query like this
select name from student where MATCH (replace(replace(replace(replace(replace(replace(replace(replace(name,":",''),";",""),",",""),".",""),"_",""),"'",""),"/",""),"-","")
) AGAINST ('+gopal' IN BOOLEAN MODE)
but it give error so how I can use match and replace together so that before doing the match with name field it remove special characters. So, if there is a record like gopa:l than also if i do search in gopal it return a row.
Thanks in advance.