How do you represent an apostrophe, because say there's something like theremin's. I obviously wouldn't be able to do this:
WHERE POSSESSION = 'theremin's'
....So what would I type to represent where an apostrophe is?
good question. it's called string escaping.
read about it here: http://www.mysql.com/doc/en/String_syntax.html
and, basically it would be 'theremin\'s'
just put a \ in front of the '