> > MySQL is, by default, case-insensitive. Try using COLLATE
> > latin1_general_cs to force case-sensitivity (the _cs bit, if you're
> > using another charset)
> Sorry, how would I do this?
For example, how would I modify this to be case sensetive...
SELECT q.itemid, g.LocationGroupName,
q.Location,
s.Title,
m.MediaTypeName, m.MediaTypeID
FROM stockquantities q
JOIN stocklocationgroups g ON (q.LocationGroupID = g.LocationGroupID)
JOIN stockitemdetails s ON (s.ItemID = q.ItemID)
JOIN mediatypes m ON (s.MediaType = m.MediaTypeID)
WHERE q.Quantity > 0
AND q.location REGEXP LocationGroupRegex = 0
Where the LocationGroupRegex field contains the regex in question.
--
Jay
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:197241
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
