Call for Help on SQL


Finally got this thing figured out. It involved changing Collations on all of the columns in the database.


I moved databases a while ago, and now my search queried in the “Keyword” search on my music section have become case-sensitive. This is bad.

Can you help?

Here is the query as it is now (searching on “test”):

SELECT [stuff]
FROM pieces p, genre g, collections c
WHERE p.genre =
AND c.code = p.collection
AND MATCH( title, instruments, description, feel, isrc )
AGAINST ("+test" in boolean mode)

Three new Pieces

This was a sort of a speed composition. 3 pieces, 3 hours each.

It starts out in some thin woods with cows and such, and then rises to great heights before
heading to the second movement – a happy little cloud thing, and finally descending into the darkness with the third movement.

This was quite a fun way to score… I’ve already got some new ideas.

Enchanted Valley
The Descent