Question

If we want to fetch from Discount table all records that have "Joe's Special Blend" (without quotation marks) value in Description column, which query is correct:

Cosmo · Accepted Answer

Single quotes are escaped by doubling them up.

Cosmo · Accepted Answer

SELECT * FROM Discount WHERE Description = 'Joe''s Special Blend'

Cosmo · Answer

SELECT * FROM Discount WHERE Description = "Joe's Special Blend"

Cosmo · Answer

SELECT * FROM Discount WHERE Description = 'Joe's Special Blend'

Cosmo · Answer

SELECT * FROM Discount WHERE Description = "Joe''s Special Blend"

Cosmo · Answer

SELECT * FROM Discount WHERE Description = Joe's Special Blend

Follow CodeGalaxy

Mobile Beta