I have a table cities
with records like
Name |Value
-------------------------+-----------------------------------------------------------------
id |62
name |Alberta
There are many more but the format is the same. I have an api in nodejs in which i receive a city name. Now, the city name can be an exact match of the name
column or a variation of it. Like it can be ‘Albarta’ or ‘Alberta City’ etc. Is there any way i can return this row by a sql query without using an external service like elascticsearch or similar? I tried like
operator but its very limited
select * from cities c where c."name" like 'Albarta%'