On 8/13/05, Robert Johnston <[EMAIL PROTECTED]> wrote:
> Is it not possible, during searches, to do "UPPER()"'s on both Search
> terms and the field they're searching on, to make them case
> insensitive again. So, for example:
>
> SELECT program_name, description WHERE (UPPER(program_name) LIKE
> UPPER('%Search String%')) OR (UPPER(description) LIKE UPPER('%Search
> String%'))
If you want to do a case-insensitive LIKE in pgsql, you just go:
SELECT field FROM table WHERE column ilike '%sEaRcH%'
Also, if you want to do bulk-inserts, use:
COPY table (id, column) FROM stdin;
1 firstrow
2 secondrow
3 thirdrow
\.
--
Mvh. Nezar Nielsen
http://fez.dk
_______________________________________________
mythtv-dev mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
