SQL like usage

Test Table. create Table test_like (like_value varchar (20 )); insert into test_like select '000000' Union all select '000000' Union all select 'abca' Union all select 'adcb 'Union all select 'abcc' Union all select 'abcd' Union all select 'abcde' Union all select 'xyz 10% off' Union all select 'xyz 20% off' Union all select 'xyz _ 123_abc '_ indicates that only one character of select * From test_likewhere like_value like is matched '1970 _'; like _ Value -------------------- 12345 (1 row affected) % indicates that only 0 or multiple characters are matched in select * From test_likewhere like_value like '000000'; like_value ------------------ 12345% (2 rows affected) use the pattern match select * From test_likewhere like_value like 'abc [ad] '; like_value ---------------- abcaabcd (2 rows affected) Select * From test_likewhere like_value like' [1A] % [5E] '; like_value -------------------- 12345 ABCDE (2 rows affected) use the escape definition Escape Character select * from Te St_likewhere like_value like '%! % 'Escape '! '; Like_value ------------------ XYZ 10% offxyz 20% off (2 rows affected) Select * From test_likewhere like_value like' %! _ % 'Escape '! '; Like_value ------------------ xyz_123_abc