[development] D7 Query Conversion

[nan wich]

I successfully converted a similar query, even though I couldn't figure out how to add "LOWER(n.title)" (so it might not work with Postgres), but how do I this one:
SELECT COUNT(n.nid) FROM {node} n WHERE n.type=':type' AND (n.title REGEXP '^[^[:alpha:]].*$')

Extra points if you tell me how to fix that for non-English.
 
 
Nancy E. Wichmann, PMP
(781) 697-6344
 
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20100622/5763bb6e/attachment.html