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
Post a Comment