[development] D7 Query Conversion

nan wich nan_wich at bellsouth.net
Mon Jun 21 01:40:32 UTC 2010

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
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/20100620/06e4272d/attachment.html 

More information about the development mailing list