Postgresql sort using a substring

Question

I have this table:

==========================
id            name       
--------------------------
1             telephone
2             microphone
3             media
4             phone

I'm using findByNameContainingIgnoreCase(String letter) to get the data that contains the substring (pho). The results are:

==========================
    id            name       
    --------------------------
    1             telephone
    2             microphone
    4             phone

But I want to also sort the output using the substring in the autosuggesting order. Like this:

 ==========================
    id            name       
    --------------------------
    4             phone
    1             telephone
    2             microphone

Does anyone know how to help?

juergen d · Accepted Answer · 2020-12-24 06:57:32Z

4

You can use position() for that and order by it

select * from your_table
where position('pho', name) > 0
order by position('pho', name)

answered Dec 24, 2020 at 6:57

juergen d

205k40 gold badges303 silver badges377 bronze badges

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

Collectives™ on Stack Overflow

Postgresql sort using a substring

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related