Mysql and sql regular expression
1) SELECT * FROM `personal` WHERE name REGEXP 'vi'
2)SELECT * FROM `personal` WHERE name REGEXP '^vi'
starting vi aa raha ho wo word dekhenga.
3)SELECT * FROM `personal` WHERE name REGEXP 'te$'
ending wprds ko dekhne ke liye
4)SELECT * FROM `personal` WHERE name REGEXP 'vishal|usrate|kale'
3no word ko dundane ke liye
5) SELECT * FROM `personal` WHERE name REGEXP '[ik]'
brackets ki value ko alag alag check karenga
6)SELECT * FROM `personal` WHERE name REGEXP '[ik]k'
ik or kk ka combination dekhanga
7)SELECT * FROM `personal` WHERE name REGEXP '^[vi]'
isme starting i se hrahi ho ya k se
8)SELECT * FROM `personal` WHERE name REGEXP '[ik]$'
ending jo hai wo i or k se hona chaiye
9)SELECT * FROM `personal` WHERE name REGEXP 'v[is]'
isme uv or ui ka combination show karenga