Mysql partial indexing, reverse indexing

Question

I have a table with a list of words.

word VARCHAR (16)

I need to create a reverse index. i.e. the word "apple" will be indexed as "elppa", the word "banana" as "ananab", etc.

Also, is it possible to index, say, a part of a word? For example, skip the first / last 1 or 2 characters:

pple (apple) anana (banana)

are these things possible?

+5

nick Jun 08 '12 at 23:13

1 answer

Harald Brinkhof · Accepted Answer · 2012-06-09T00:58:08+0000

, , , n , . mysql CREATE INDEX.

, mysql REVERSE, . .

, Postgresql, , reverse(col_name) . , mysql . ( 9 potgresql reverse() native, )