To get the equivalent with LIKE, you'd have had to use % wildcards at the end:

      
mysql>
mysql> SELECT 'abcdef' LIKE 'abc%';
+----------------------+
| 'abcdef' LIKE 'abc%' |
+----------------------+
|                    1 |
+----------------------+
1 row in set (0.00 sec)

mysql>

Related examples in the same category

1.	Where clause: like and %
2.	like B%
3.	like %r
4.	LIKE '%e_'
5.	Like and concat
6.	Like and escape
7.	LIKE '%is%'
8.	LIKE '______' (underscore)
9.	LIKE '______%' (underscore and %)
10.	LIKE '_r%r_'
11.	LIKE '_@%%@%_' ESCAPE '@'
12.	To reverse the sense of a pattern match, use NOT LIKE.
13.	SQL patterns do not match NULL values. This is true both for LIKE and NOT LIKE
14.	LIKE Search Pattern
15.	Controlling Case Sensitivity in Pattern Matching. By default, LIKE is not case sensitive:
16.	Pattern Matching: LIKE and %

To get the equivalent with LIKE, you'd have had to use % wildcards at the end: : Like « Regular Expression « SQL / MySQL

Related examples in the same category