issue in full text search using with replace.

[Gopal patel]

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.