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 |
|
#1
| |||
| |||
| hi... Can anyone give details about "escape character" in MySql ? |
|
#2
| |||
| |||
| 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.. |
|
#3
| |||
| |||
| Hi murali, thanks for your reply.... i want to search a string from a table: search string: hell\%test how do u make query for this? |
|
#4
| |||
| |||
| 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... |
|
#6
| |||
| |||
| Hi, thanks its working... Can you give, other escape characters? |
|
#7
| |||
| |||
| 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 | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| MySQL supports indian language character sets | priyan | Database Support | 17 | 01-11-2010 12:25 AM |
| Guide to Character Encoding in HTML / PHP / MySQL ??? | bordeauxkevin | PHP Programming | 0 | 12-29-2008 08:50 AM |
| What is the wildcard character in SQL? | S.Vinothkumar | Database Support | 3 | 04-10-2008 10:50 PM |
| How to get ASCII Value of a first character in a string in php? | $enthil | PHP Programming | 1 | 01-06-2008 10:48 PM |
| Character Embedding | geoblow | Flash Actionscript Programming | 0 | 09-18-2007 12:11 AM |
Our Partners |