Exact word match (non-English characters)

Question

I have a table in my Mysql db (utf-8). I want to get exact word matches from this table. My query is:

SELECT matched_rows FROM MY_TABLE WHERE string = 'MY_STRING'

Problem is when I search for 'ağaç' (tree in English) I got all rows with ağaç, agac, ağac, agaç. what I want to get is only 'ağaç' not the rest. I also don't want results with something agac.

How do I get this effect?

refer this post http://stackoverflow.com/questions/5131248/mysql-selecting-exact-word-with-match-query — abhijit, Mar 10 '12 at 12:35

score 1 · Accepted Answer · answered Mar 11 '12 at 17:07

1

i followed @gintas answer and made some modifications. in the end this one worked for me:

SELECT ROWS FROM MY_TABLE WHERE CONVERT(string_field_name USING latin5) = CONVERT('MY_STRING' USING latin5)

answered Mar 11 '12 at 17:07

mumin aydin

63
7

score 0 · Answer 2 · answered Mar 10 '12 at 13:04

0

You should try defining collation in the query

SELECT matched_rows FROM MY_TABLE WHERE string = 'MY_STRING' COLLATE utf8_general_ci

answered Mar 10 '12 at 13:04

gintas

2,118
1
18
28

thanks, but i got this eeror `COLLATION 'latin5_turkish_ci' is not valid for CHARACTER SET 'utf8'` – mumin aydin Mar 10 '12 at 14:13

score 0 · Answer 3 · edited May 23 '17 at 12:21

0

SELECT * FROM users WHERE email REGEXP '[[:<:]]abhi[[:>:]]'

 try this link on SO i think you didnt try this?

LINK: url

edited May 23 '17 at 12:21

Community

1
1

answered Mar 10 '12 at 13:24

abhijit

1,958
3
28
39

thanks! but this gives me all strings containing my SEARCH_WORD. – mumin aydin Mar 10 '12 at 14:16

Exact word match (non-English characters)

3 Answers3