Error - View Single Post - Find and replace single quotes in a sql query

**Anilrgowda** · 22-Oct-2007, 12:25 AM

>select * from database where field like '%''%'
should work correctly. assuming that it is indeed a single quote, and not a backquote ` or other character ? or double quote " in there...

22-Oct-2007, 12:25 AM	#2 (permalink)
Anilrgowda Administrator Posts: 18,715 Join Date: Jan 2006 Rep Power: 10 IM:	Re: Find and replace single quotes in a sql query >select * from database where field like '%''%' should work correctly. assuming that it is indeed a single quote, and not a backquote ` or other character ? or double quote " in there... ------------------