user1391049 user1391049 - 3 months ago 27
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?


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.