sql - MySQL SELECT values with more than three words -


i have following code

select * list name '___' order name; 

i trying shows names 3 or more words. displays names 3 characters cannot seem work out correct syntax this.

any appreciated thankyou

if assume there no double spaces, can do:

where name '% % %' 

to names 3 or more words.

if can have double spaces (or other punctuation), want regular expression. like:

where name regexp '^[^ ]+[ ]+[^ ]+.*$' 

Comments

Popular posts from this blog

javascript - how to protect a flash video from refresh? -

android - Associate same looper with different threads -

visual studio 2010 - Connect to informix database windows form application -