|
12/24 |
2004/1/8 [Computer/SW/Database] UID:11714 Activity:nil |
1/7 How do I escape an apostrophe character in an SQL query SELECT * FROM foo WHERE bar LIKE '%it\'ll be a long summer%' \_ In Oracle, you escape apostrophes with another apostrophe. \_ Thanks. \_ It's different for different dbs. The above works for a number of different ones. |
12/24 |
|