SQL Queries....

[Anton Markov]

MySQL also supports regular expressions by replacing 'LIKE' with 'RLIKE'.

Also, I think that MySQL is case-insensitive by default (unless you use 
the BLOB type).

cbbrowne-HInyCGIudOg at public.gmane.org wrote:

>PostgreSQL also supports, using the ~ operator, pretty full-scale
>regular expressions.
>
>So, you might have a query to look for people with names starting with
>"B":
>
>  select * from some_table where name like 'B%';
>
>If you need case insensitivity, you might use:
>
>  select * from some_table where lower(name) like 'b%';
>
>  
>


--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml