mysql full text search with html entities?

[joeshacks]

so here's my problem.. i'm trying to search a large database that contains words like jalapeno, but the n in jalapeno has a ntilde, like jalapeño.. but it would make since when someone searches for jalapeno it should also find all the words that have the html entity as well.. so i am currently doing a sql select like..

 

select * from tbl where REPLACE(col, 'ñ', 'n') like '%jalapeno%';

 

is there a way to do this similar kind of thing with full-text searches?

[fenway]

You shouldn't be storing HTML entities in your DB.

[bubblegum.anarchy]

Save some space and time with a query that converts all existing entities to their equivalent characters.

[fenway]

Not just that, but with a proper charset conversion in the query, you should be able to solve your query issue.