user1391049 user1391049 - 4 months ago 37
SQL Question

SQL LIKE query in Tarantool

What is a proper way to make a query in Tarantool DB with SQL LIKE keyword?
For example:

SELECT * FROM space where smth LIKE '%some_value%';


Can I search for values using a part of index or I need to write my own LUA script for such functionality?

Answer

Yes, you shoud write Lua Script, that'll iterate over space and use lua function gsub on 'smth' field of tuple. There's no way, for now, to search for part of string.

Comments