user1391049 user1391049 - 1 year ago 129
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 Source

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.