mysql: matching a query letter by letter

[Darko]

I am in the process of learning MySQL and querying, and right now working with PHP to begin with.For learning purposes I chose a small anagram solver kind of project to begin with.I found a very old English language word list on the internet freely available to use as the DB.I tried querying, find in set and full-text search matching but failed.How can I:Match a result letter by letter?For example, let's say that I have the letters S-L-A-O-G to match against the database entry.Since I have a large database which surely contains many words, I want to have in return of the query:\[code\]laggoalgoalsslaglog... and so on.\[/code\]Without having any other results which might have a letter used twice.How would I solve this with SQL?Thank you very much for your time.