chewpichai
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.
Older Posts
Home
Subscribe to:
Posts (Atom)