* onemind <[EMAIL PROTECTED]> [2006-06-25 16:05]:
> If i had a table wit a word column that had a huge list of
> words and i wanted to select every word that contained all
> these letters "qdsa".
SELECT *
FROM words
WHERE
word LIKE '%q%'
AND word LIKE '%d%'
AND word LIKE '%s%'
AND word LIKE '%a%'
And that’s going to be slow like molasses. It’s not something SQL
is well suited to.
If you need to do this a lot, I suggest precomputing the kinds of
facts about each word that you’ll want to query and storing them
in a column or dependent table so you can create indices and
query them quickly.
Of course if the performance of the simpleminded approach is
sufficient for you, then all the better.
Regards,
--
Aristotle Pagaltzis // <http://plasmasturm.org/>
