MySQL Forums
Forum List  »  Full-Text Search

issue in full text search using with replace.
Posted by: Gopal patel
Date: April 14, 2011 07:21AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
issue in full text search using with replace.
4818
April 14, 2011 07:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.