Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to make an efficient check constraint for an e-mail field in Firebird

Tags:

sql

firebird

How to make an efficient check constraint for an e-mail field in Firebird (if field value not null)?

thanks, Wilfried

like image 371
Wilfried Visser Avatar asked Feb 22 '23 20:02

Wilfried Visser

1 Answers

You could use the SIMILAR TO operator to test against regular expression pattern, something like

CHECK(emailfield SIMILAR TO '[[:ALNUM:]._%+-]+@[[:ALNUM:].-]+\.[[:ALPHA:]]+')
like image 183
ain Avatar answered Apr 27 '23 17:04

ain
Sign in to Comment

Related questions

MySQL Statement extremely slow even with indexes
How do I use group by on one column which is having many entries?
Referencing the value of the previous calculcated value in Oracle
C# Dynamic SQL INSERT ... SELECT
Using a current row value into a subquery
Select unique count of rows referenced
Interview : update table values using select statement
Converting Numbers to Words in MYSQL result! Using Query
Writing SQL Insert Function
how to set unique primary key for all table in same database
Simplemembership - adding email field and use as login-name
How to check username and password case sensitive?
MySQL how to find parent with exact set of children?
linq to sql select as command
What kind of indexes will help me in this MERGE query?
Set Max number of Queries to specific database user in SQL Server 2008 R2
Cursorfetch:The number of variables declared in the INTO list must match that of selected columns
The given value of type String from the data source cannot be converted to type bigint of the specified target column
VB | Loading SQL Query into Combobox
SQL Output Syntax

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!