This is a discussion on Escape Character in MySql within the Database Support forums, part of the Web Development category; hi... Can anyone give details about "escape character" in MySql ?...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
| |||
| Hi, Escape Character,Yes available in MYSQL as same as Oracle. Here are some examples. 1. SELECT "Its \n really \n working"; This will list the values as every character in new line Output: Its really working 2. SELECT "P.R & Sons"; Will List the Value with the Ambersent 3. SELECT "This is Mayor's Book"; Will List the Value with the single quote.
__________________ -Murali.. |
| |||
| Hi buddy, -- For mysql SELECT * FROM test WHERE name LIKE '%hell\\\%test%'; -- For oracle SELECT * FROM TEST WHERE NAME LIKE '%hell\\%test%' ESCAPE '\';
__________________ Keep smiling... |
| |||
| May be these links help u to know about Escape Characters. Escape Characters Oracle Wildcards Wildcard Characters Escape Character How to Escape Characters in Oracle PL/SQL Queries My Digital Life
__________________ -Murali.. |
![]() |
| Thread Tools | |
| Display Modes | |
| |
LinkBacks (?)
LinkBack to this Thread: http://www.discussweb.com/database-support/1607-escape-character-mysql.html | |||
| Posted By | For | Type | Date |
| 에서 문자를 이스케이프하는 방법 oracle 1 / sql 쿼리»내 디지털 라이프 | This thread | Refback | 03-20-2008 10:56 PM |
| Как избежать символов в Oracle PL / SQL запросов »Моя Цифровая жизнь | This thread | Refback | 02-08-2008 03:54 AM |
| Cómo escapar caracteres en Oracle PL/SQL pregunta” mi vida de Digital | This thread | Refback | 09-20-2007 10:33 AM |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| openSTA and end of file character | cindrella | Software Testing | 0 | 02-29-2008 11:12 AM |
| Substring of a string from a particular character | $enthil | PHP Programming | 4 | 01-02-2008 02:39 AM |
| MySQL supports indian language character sets | priyan | Database Support | 16 | 12-12-2007 04:40 AM |
| Character Embedding | geoblow | Flash Actionscript Programming | 0 | 09-18-2007 01:11 AM |
| NULL character within a string | vigneshgets | C# Programming | 1 | 08-01-2007 05:07 AM |