hi...

Can anyone give details about "escape character" in MySql ?

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 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?

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...

Hi Raj,

Hope Got answer for your question.

__________________
-Murali..

Hi,

thanks its working...

Can you give, other escape characters?

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..