How to select rows which start with digit in PostgreSQL?
Posted
by noxvile
on Stack Overflow
See other posts from Stack Overflow
or by noxvile
Published on 2010-04-18T11:41:04Z
Indexed on
2010/04/18
11:43 UTC
Read the original article
Hit count: 241
postgresql
|sql
Need to get rows starting with digit e.g. '1test', '32 test'. I tried
SELECT * FROM table WHERE name LIKE '[0-9]%'
as I used to do in MSSQL but it wasn't successful.
© Stack Overflow or respective owner