How do I write SQL to fetch strings that begin with % in Oracle?

Question

Could someone please assist on how to fetch the data in SQL for all the strings starting with %%string?

I tried below to escape %% but it didn't work

SELECT * FROM Tablename WHERE host LIKE ‘[%][%]%’

user1794469 · Accepted Answer · 2020-03-30 18:29:57Z

1

This link says you need to escape them with {} or \. So your example should be something like:

SELECT * FROM Tablename WHERE host LIKE ‘\%\%%’;

You could also try some select strings to see what gets escaped:

SELECT '\%{%%}' FROM dual;

answered Mar 30, 2020 at 18:29

user1794469

4,2471 gold badge27 silver badges42 bronze badges

1 Answer 1