Escape Character in MySql

raj · #1 07-12-2007, 12:18 AM

hi...

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

Murali · #2 07-12-2007, 03:16 AM

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.

raj · #3 07-12-2007, 06:11 AM

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?

priyan · #4 07-12-2007, 06:24 AM

Hi buddy,

-- For mysql
SELECT * FROM test WHERE name LIKE '%hell\\\%test%';

-- For oracle
SELECT * FROM TEST WHERE NAME LIKE '%hell\\%test%' ESCAPE '\';

Murali · #5 07-12-2007, 09:53 PM

Hi Raj,

Hope Got answer for your question.

raj · #6 07-12-2007, 10:07 PM

Hi,

thanks its working...

Can you give, other escape characters?

Murali · #7 07-13-2007, 04:27 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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