How do I build an SQL query which returns rows based on whether or 
not strings in a column contain more than one word

eg.

SELECT name
FROM contacts
WHERE WORD COUNT(name)>1

I am aware that such a query is bogus but it seems as if there must 
be a straightforward way of doing this.

thanks

Tommy Beavitt

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to