Skip to content
Advertisement

Select value with prefix separated by dot in postgresql

I have a table t_table :

This is the query code : SELECT * FROM t_table

and the result is below

I want to select the code with suffix “.b” only. How to do it? I am new to postgreSQL

Advertisement

Answer

If you want strings that end with '.b' (that’s a suffix):

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement