[development] D7 Query Conversion

nan wich nan_wich at bellsouth.net
Tue Jun 22 17:03:01 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
(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 

More information about the development mailing list