Showing posts with label RegEXP. Show all posts
Showing posts with label RegEXP. Show all posts

2007-10-06

How to use MySQL RegExp

You can use RegExp in MySQL like this.
- SELECT column_name FROM table_name WHERE column_name COLLATE utf8_bin REGEXP '^.* [a-zI]$'

Note: COLLATE is use for use case sensitive in SQL.