var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: a special select
Hi, i have a table with a column "Album", defined as varchar.
Suppose i have the following rows:
and i want to select all records with the album field starting with numbers, i.e., id=4,5,6. how can i do this please?
thanks in advance!
You might want to create an index on substring(album,1) if your table is very large (otherwise PG will always do a sequential scan, which might be slow)
SELECT id, album
WHERE substring(album,1) in ('1','2','3','4','5','6','7','8','9','0');