better search words

[devels]

I have for example the word 'spider-man 3' or 'mr. bean' in my database.

Is it possible to find the corresponding id's when the search string is without punctuation marks like searching with the string: 'spiderman' or 'mr bean'?

I'm trying to accomplish it by using MATHC AGAINST, also in BOOLEAN MODE but with no success.

[Roger_Ramjet]

FTS interprets the punctuation as word delimiters so does not use them as part of the word, and will also ignore mr as it is too short. You would have to use a regex to strip out the hyphen and use 'spider-man spiderman' in your match against.