using LIKE operator in mysql

Question

I want search companies from my company table when i give company name...here am using like operator

eg: saravana stores

it gives the result saravana stores texttiles,saravana stores thanga maligai,etc(which is contained with saravana stroes...coz of using LIKE operator)

Now my problem is when i give lcd projectors in the companyname, also want to fetch the records which are contained with the only projector word...but like operator gave the results with the 'lcd projector'

am making clear?

You can make use of or in your query...

Himadri
– Himadri

2010-06-25 11:16:50 +00:00
Commented Jun 25, 2010 at 11:16 — Himadri
– Himadri, Commented Jun 25, 2010 at 11:16
you should google "like mysql" at least before posting

Andrey
– Andrey

2010-06-25 11:18:07 +00:00
Commented Jun 25, 2010 at 11:18 — Andrey
– Andrey, Commented Jun 25, 2010 at 11:18

Mark Byers · Accepted Answer · 2010-06-25 11:16:08Z

4

Try:

WHERE (name LIKE '%saravana%' OR name LIKE '%stores%')

This has two disadvantages:

It can't use an index so it will be slow.
It can give you matches you don't want like 'bestorest' matches '%stores%'.

You might want to use a full text search instead. You could also consider an external engine such as Lucene.

answered Jun 25, 2010 at 11:16

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ceteras · Accepted Answer · 2010-06-25 11:30:02Z

0

If you want proper fultext search, I highly recommend trying Lucene or Sphinx. I know it would get a little complicated, but it's worth it for the end result.

answered Jun 25, 2010 at 11:30

ceteras

3,3882 gold badges21 silver badges14 bronze badges

Comments

GOsha · Accepted Answer · 2010-06-25 11:49:55Z

0

Mark Byers is right.
To get more efficiency
After query dividing to words you can modify search input to get word base and unify searching to get smth lika:
WHERE (name LIKE '%sarava%' OR name LIKE '%stor%')

answered Jun 25, 2010 at 11:49

GOsha

6895 silver badges13 bronze badges

Collectives™ on Stack Overflow

using LIKE operator in mysql

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related