Dmytro
Reputation: 90
How to SELECT all names that consist of 2 words
How to use LIKE to search for all names that consist of 2 any words.
Upvotes: 0
Views: 2028
Answers (1)
Gordon Linoff
Reputation: 1270723
Assuming words are separated by a space:
where name like '% %' and name not like '% % %'
Upvotes: 5
Related Questions
- SQL SELECT WHERE field contains words
- Extracting Names That Has Specific Word
- SQL - Select rows by entering two words
- SQL SELECT only field where it contains words
- SQL Query to SELECT strings which are either words
- MySQL Select values with two or less words
- Sql select record that match multiple words for a give column
- SQL Query to search by name(containing combination of two or more word)
- select entries that has one word
- mysql query where second words starts with a letter