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