im using Like to select all data which has single quote in name like Jon's.
select * from users where file_name like '%'%';
I then want to remove the ' from all results.
Ideas?
-
Do you mean single apostrophe, ' , or the backtick ` ?Craig Ringer– Craig Ringer2013-12-09 08:32:58 +00:00Commented Dec 9, 2013 at 8:32
Add a comment
|
1 Answer
Double quotes in SQL to escape them:
select * from users where file_name like '%''%';
(For any vaguely recent PostgreSQL version; the non-standard escape-string phrasing E'%\'%' will work with even very old PostgreSQL versions, but not other databases.)
It sounds like you want to remove those characters from the file names. If so, something like the untested:
update users
set file_name = replace(file_name, '''', '')
should do the trick.