Multiple choice technology databases

There is a % sign in one field of a column. Say for example table test_chk has a column name1 which contains a value “desdf%dsf”. What will be the queries to find it?

  1. SELECT * FROM test_chk ;

  2. select * from test_chk where name1 like '%%\%' escape ''

  3. select * from test_chk where name1 like ' \ ' escape '';

  4. select * from test_chk where name1 like '%!%%' escape '!'
Reveal answer Fill a bubble to check yourself
A,D Correct answer

Keep practicing — related questions