Compare text from input with database field

Hi everyone!

I have a task:
check the correctness of the entered word in the input
The database stores a list of the correct variants (the word can be written in different registers, for example)
If you use the function “contains”, then a match will be found even if you enter part of the word
how can I check the whole word match???

for example:The database contains a list of words Banana, banana, bananas
If I enter ban, bana … “contains” will be “yes”

I will be grateful for any ideas!

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.