I know most of this issue is me not knowing how to use SIMILAR TO and regex so any help would be great.
I am trying to match a product title entered into a search field with titles already in a database.
for example in the database the title is "Robocop"
when I look up another title say ... "Robocop Blu-Ray" or "Robocop (The Criterion Collection)" or "Prime Directives Robocop Series"
how can I get it to return a match?
Thanks in advance.