Hello, This is my first post here .. there is table in postgresql like this: id | prefix_no | description ----+-----------+-------------------------- 1 | 085 | SN 085 2 | 0600 | ERA 0600 3 | 0510 | Orange 0510
How create below query using sqlalchemy ??: "SELECT * FROM kb_prefix where '08512345' like prefix_no || % order by length(prefix_no) desc limit 1" --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
