View Single Post
  #4  
Old 07-12-2007, 06:24 AM
priyan priyan is offline
D-Web Sr.Programmer
 
Join Date: Mar 2007
Posts: 133
priyan is on a distinguished road
Default Re: Escape Character in MySql

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...
Reply With Quote