Re: mysql prompt suddenly changed

[Peter Brawley]

> Is an apostrophe is not permitted inside a text string?

Sure it is, but you need to tell MySQL that a particular apostrophe is data and not a string delimiter.

You do that by "escaping" it, ie preceding it with the "escape" char, the backslash \` ...

select "Bob\'s lunch";
+-------------+
| Bob's lunch |
+-------------+
| Bob's lunch |
+-------------+