Skip to main content
eZabel
Login
0 online
Forum / SQL View full thread →
theremin Mar 21, 2004

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 repr...

iwz iwz

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 '

← View full thread

Welcome Back to eZabel

It's been a while. Here's what's new.

eZabel Lore

A complete history of our community — stats, Hall of Fame, legendary threads, and more.

View the Lore →

Everything Preserved

All 225,969 pieces of content from 2000–2014 are here — forums, messages, journals, photos, polls, and events.

💎

Gems

Spot something you love — a legendary comment, a classic thread, a great photo? Log in and click the diamond icon to mark it as a Gem. Add a note about why it's special. The best stuff surfaces on the Gems page.