Hi pals,
Here,i share regular expression tips&tricks,it is more usefult to u


REGULAR EXPRESSION

Character|Description|Example

^(Cap)-Match the beginning of the string-SELECT 'fofo' REGEXP '^fo';


Thanks,
Prasath.K

ASP.NET provides a suite of validation controls, which make validating inputs on web forms extremely easy compared to the same task using legacy (or classic if you prefer) ASP. One of the more powerful validators is the RegularExpressionValidator which, as you might guess, allows you to validate inputs by providing a regular expression which must match the input. The regular expression pattern is specified by setting the ValidationExpression property of the control. An example validator

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!

Hi,
here after,i share another regular expression

REGULAR EXPRESSION
Character Description Example
$(Dollar) Match the end of the string SELECT 'fo\no' REGEXP '^fo\no$';


Thanks,
Prasath.K

Hi,
Here,another regular expression

REGULAR EXPRESSION

.(Dot) Match any character (including carriage return and newline).

Example
SELECT 'fofo' REGEXP '^f.*$';

Hi,
Below explain regular experssion

REGULAR EXPERSSION
a* Match any sequence of zero or more a characters

Example
SELECT 'Ban' REGEXP '^Ba*n';

Hi,
Another regular experssion

REGULAR EXPERSSION
a+ Match any sequence of one or more a characters

Example

SELECT 'Ban' REGEXP '^Ba+n';

hi techies,
here another regular experssion

REGULAR EXPERSSION
a? Match either zero or one a character

Example

SELECT 'Bn' REGEXP '^Ba?n';

Hi,
Another regular experssion

de|abc Match either of the sequences de or abc.

Example
SELECT 'pi' REGEXP 'pi|apa';

Thanks,
Prasath.K

Hi pals,
Another regular expression

(abc)* Match zero or more instances of the sequence abc

Example

SELECT 'pi' REGEXP '^(pi)*$';