MySQL SQL - How To Use Regular Expression in Pattern Match Conditions
Interview Question Database For Software Developers
|
|
| How To Use Regular Expression in Pattern Match Conditions | | How To Use Regular Expression in Pattern Match Conditions? - MySQL FAQs - Introduction to SQL Basics | | By: FYIcenter.com | If you have a pattern that is too complex for LIKE to handle, you can use the
regular expression pattern condition: REGEXP.
The following tutorial exercise provides you some good examples:
SELECT 'FYICenter.com' REGEXP '.*fyi.*' FROM DUAL;
1
SELECT 'FYICenter.com' REGEXP '.*com$' FROM DUAL;
1
SELECT 'FYICenter.com' REGEXP '^F.*' FROM DUAL;
1
| | ID: 1077 | Rank: 1070 | Votes: 0 | Views: 42 | Submitted: 20070511 |
1081
:-) | | What Are DDL Statements | | What Are DDL Statements? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements... | | Submitted: 20070511 |
|
Copyright © 2009 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|
Atom feed
List view