[Sasquatch3o3]

Classes (class, type, country, numGuns, bore, displacement)
Ships(name, class, launched)
Battles(name, date)
Outcomes(ship, battle, result)

Find the names of all ships whose name consists of three or more words.

I have

SELECT name
FROM Ships
WHERE name LIKE '% % %';

It still returns every tuple in the database, I have no idea where to go from here, any help is greatly appreciated.

This post has been edited by Atli: 13 September 2012 - 09:34 PM
Reason for edit:: Please use [code] tags when posting code.

[Atli]

I'd try using the REGEXP_COUNT function.

SELECT name
FROM Ships
WHERE REGEXP_COUNT(name, ' +') > 2