Bug #60868 this is very usefull site

• Submitted: 14 Apr 2011 10:40
• Modified: 14 Apr 2011 11:18
• Reporter: Gopal patel
• Status: Not a Bug
• Category: MySQL Server: FULLTEXT search
• Severity: S3 (Non-critical)
• OS: Any
• CPU Architecture: Any

[14 Apr 2011 10:40] Gopal patel

Description:
i have 2 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 i give error so how i can use this query with full text index and also replace with some special character.plz reply as soon as possible

How to repeat:
when bug comes

[14 Apr 2011 11:18] Valeriy Kravchuk

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.