• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Searching and matching keyword

 
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello All,

I am using Postgres Db and I have this following problem:

My requirement is getting all the results based on the keyword but, the results should be ascending based on matching the keyword

For example I have this Number_Prefix table:

id prefix priority
1 90212 1
2 90212 2
3 90216 1
4 9021 1
5 9021 2
6 90 1

when I make a select with keyword = '90212' on prefix column, what I want to see is :

1 90212 1
2 90212 2
4 9021 1
5 9021 2
6 90 1

or I make a select with keyword = '9021' on prefix column, what I want to see is :

4 9021 1
5 9021 2
6 90 1

so the query will look for 9021 then 902 and 90 and so on.

can this be done in one single sql call?

thanks in advance.

Yigit
 
Ranch Hand
Posts: 2908
1
Spring Java Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Not sure, but try.
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yigit,
The order part is easy "order by keyword desc, priority".

For the rest of it, I think you'd need a stored procedure to do it in one call - looping by substring.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic