How to select rows which start with digit in PostgreSQL?
- by noxvile
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.
Search Results
Search found 2 results on 1 pages for 'noxvile'.
Page 1/1 | 1
-
-
How to check group for containing certain elements in SQL?
- by noxvile
I have a simple table: id num 1 7 1 5 1 4 2 5 2 4 2 7 3 4 3 7 How to select ids having num 5 as well as 7 and 4 For this example ids: 2, 3Read the article
