select * from product
where
name like '%foo%'
and len(name) <=6;
btw, how do u define similarity? i'm guessing it wouldn't be this
simple...
On Sep 12, 5:12 am, Snoopy Me <thesnoop...@gmail.com> wrote:
> You are given the amazon.com database which consists of names of
> millions of products. When a user enters a search query for particular
> object with the keyword say "foo" , output all the products which have
> names having 50% or more similarity with the given keyword ie "foo"
>
> Write the most efficient algorithm for the same.
--
You received this message because you are subscribed to the Google Groups
"Algorithm Geeks" group.
To post to this group, send email to algoge...@googlegroups.com.
To unsubscribe from this group, send email to
algogeeks+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/algogeeks?hl=en.
