SQL query to search for records containing an apostrophe (')

Question

I'm ingesting data into IBM MDM and we are finding source records with row key's containing an apostrophe (') which MDM cannot accept and therefore rejects the records. I want to query the source records to count how many records are affected, but with SQL apostrophes open and close text strings. Is there a way to make a query like

select count (*) from table1 where field1 like '%'%' ;

Basically, I want to be able to search for a string of letters that have an apostrophe in it like...roundy's

Usually 2 x `'` escape a `'` so `like '%''%'` – Alex K. Jul 12 '17 at 15:18 — Alex K., Jul 12 '17 at 15:18

score 1 · Answer 1 · answered Jul 12 '17 at 15:48

1

Use backslash to escape special characters. To get aa'bb use aa\'bb.

Escape characters

answered Jul 12 '17 at 15:48

Marek Vitek

1,573
9
20

score 1 · Answer 2 · answered Nov 13 '19 at 04:48

1

" instead of ' will get you what you want

answered Nov 13 '19 at 04:48

victor

93
1
1
10

Could you please make an example or add some more explanation why this would help? – slfan Nov 13 '19 at 05:08

SQL query to search for records containing an apostrophe (')

2 Answers2