The % wildcard returns any number of characters : Percentage wildcard « Regular Expression « SQL / MySQL






  1. SQL / MySQL
  2. Regular Expression
  3. Percentage wildcard

The % wildcard returns any number of characters

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








Related examples in the same category

1.Usage of the % wildcard
2.% means 0 or more characters.
3.show records where the model is a "cross cut" type