Usage of the % wildcard : Percentage wildcard « Regular Expression « SQL / MySQL






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

Usage of the % wildcard

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








Related examples in the same category

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