Search of a certain character in MySQL and assigning multiple values to it

arnoldc

I have a problem considering the search of a certain character (w. multiple value) in a MySQL database. When I query a string in a database, lets say, the string '%bice%', is there a possibility to somehow order the MySQL to realise that f. e. the character c could have multiple values, like č or Ć ? Note that I'd like to avoid sending "... (row LIKE %bice%) or (row LIKE %bi&#269e%) or (row LIKE %bi&#262e%) ..." alike queries, as if the string is huge with many non-english characters, it would lead to numerous combinations.
Basically, if I search for a 'bice', I'd like to get 'bi?e' or 'bi?e' as results as well.
Any ideas? Thank you in advance.

coolT

Can you try this?

SELECT * FROM table
WHERE match(fieldname) against ('word to search for' in boolean mode)

arnoldc

Originally posted by coolT
Can you try this?

SELECT * FROM table
WHERE match(fieldname) against ('word to search for' in boolean mode)

Thank you for your fast reply, but unfortunately the MATCH ... AGAINST query can't help too much in this case...
A better example: lets say if I'd like assign the letter "b" in the query to all the "be", "beaut", "tumm" words in the database? So a query like SELECT table WHERE row LIKE '%by%' would find the words "abey", "tummy" or "beauty" too, not just "bypass" or "abbys" e. g. Would that be possible in any way?

coolT

I'm not sure where you are going with this - but would this work for you?
SELECT table WHERE row LIKE '%b%y%'

arnoldc

Sadly, no. Then the query will most likely find all the words with a "...b...y..." scheme, whilst I'd like to assign a letter to just a few fords (f. e. just to those three I've mentioned). This way, the query still won't find the word "tummy"...
An even more annoying problem shows up if a string contains several "b"s (babble). That way, I'd have to send all the combinations of the word trough the query ('%abeyaabeyabeyle%', '%abeyaabeytummye%'... and so on...) It's a quite nasty example, but it pictures what I mean - imagine if I'd have a list of 100+ words to replace the letter "b". Note that I wouldn't like to find the word "abey" or "tummy" on their own!