[sqlite] about text search

[Lloyd Dupont]

let's say I have a table 
like that
CREATE TABLE Infos
{
    id INTEGER,
    text TEXT
}

and I want to search a with the word... 'apple', 'cinamon', 'cake'
I could write 
SELECT FROM infos WHERE text LIKE '*apple*' AND text LIKE '*cinamon*' AND text 
LIKE '*cake*'

Now, isn't there a way to improve anything (with index or otherwise?)