Strings with string's

im trying to select something that has an Apostrophe in it, for example word.title = 'didn't'
so is there a way in SQL to quote the whole thing without getting an error?

What you do is that you quote the apostrophe.


And if you use PHP then you can use the mysql_real_escape_string() function and it will quote all characters that can cause an error for you.

'Electrician\'s book'

get: ORA-01756: quoted string not properly terminated

the reason you got an error is that you tried to run some syntax which works in mysql but doesn't work in oracle

the reason you got that mysql syntax is because you posted your question in the mysql forum!!

in oracle, you must use two consecutive single quotesincidentally, that also works in mysql, and in fact, that's the standard sql way to do it

i will move your thread over to the oracle forum

You din't mention that you where using Oracle and since this is a MySQL forum that is rather important to mention because the DB's differ in syntax.

Use double apostrophe in that case:


When they are grouped together like that they will be considered as one in the string.

oh sorry, i thought oracle was mySQL... ive just started learning.

so whats the difference between the 2?

Then you have a lot to learn my friend.


Over 49,000 employees and they are as similar as David and Goliath regarding company size, revenue and technology.

that's like saying "oh, i thought the lada was the same as the ferrari"

they are both cars ...