There is a % sign in one field of a column. What will be the query to find it?

Q

There is a % sign in one field of a column. What will be the query to find it?

✍: Guest

A

SELECT column_name FROM table_name WHERE column_name LIKE ‘%\%%’ ESCAPE ‘\’;

2011-12-06, 2609👍, 0💬