How to use string that contains ' in SQL “IN” clause?

Question

I want to use string like  'Apple's' in SQL "IN" clause query.

example:

select * from tbl_fruit where nm_fruit IN(''Apple's'','Orange');

How to make the above query work correctly ?

Answer 1

Double the single quotes,

select * from tbl_fruit where nm_fruit IN ('Apple''s', 'Orange')

but if you do it on the application level, make sure you parameterized the query.

If you want to learn more about SQL, Check out this SQL online course by Intellipaat.

For more information visit :