Need a little help in SQL query...take a look if you are good at it :)

[eggman]

In regarding my project, i had to use a bit of SQL and since I"m not good at it I need your help!

Here it goes...

To display all the names that have EXACT MATCH in the database I used this query

select * from word_location where word =[I]keyword[/I]

where keyword is a variable.

To display all the names that have PARTIAL MATCH in the database I used this query

select * from word_location where word like %[I]keyword[/I]%

However second query also gives all the Data That Have EXACT match along with partial match.

SOmeone please post a query which only gives PARTIAL MATCH excluding exact match!

 

[Vasishta.Sushant]

select * from word_location where word like %keyword% except select * from word_location where word =keyword

 

[greenhorn]

where word like %keyword%
and word not =keyword?
/very rusty(almost rusted solid SQL) but had to try

 

[Vasishta.Sushant]

The one I mentioned will work using the internal SQL engine which works on the logic given by Greenhorn. Try that.

 

[raksrules]

@eggman

Use this

select * from word_location where word like %keyword%

MINUS

select * from word_location where word =keyword

You will get what you want

 

[eggman]

@Vasishta.Sushant : Thaks..........your code works

I havent tried greenhorn and raksrules 's ...but thanks for the help...I'm sure it's right too

 

[greenhorn]

no wonder i failed SQL tuning 101 :ashamed:

Oh well

 

[raksrules]

no wonder i failed SQL tuning 101 :ashamed:
Oh well

OT: One more reason for you to quit outfosys :lol:

 

[greenhorn]

OT: One more reason for you to quit outfosys :lol:

Not really, I'm a tester. It really doesn't matter if i can't code

 

[eggman]

^^Lol!!!!!!!!