Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SQL Server - regex filtering using LIKE
-------------------------------------------------------------------------------- -- Create Sample Data -------------------------------------------------------------------------------- WITH sample_data AS ( SELECT 0 AS [id], '123' AS [val] UNION ALL SELECT 1 AS [id], 'abc' AS [val] UNION ALL SELECT 2 AS [id], 'atc' AS [val] UNION ALL SELECT 3 AS [id], 'a1c' AS [val] UNION ALL SELECT 4 AS [id], 'abbc' AS [val] UNION ALL SELECT 5 AS [id], 'a11c' AS [val] ) SELECT * INTO [sample_data] FROM sample_data ; ALTER TABLE [sample_data] ADD CONSTRAINT [PK_sample_data] PRIMARY KEY([id]) ; -------------------------------------------------------------------------------- -- View All -------------------------------------------------------------------------------- SELECT * FROM [sample_data] ; -------------------------------------------------------------------------------- -- Compare Filter Expressions -------------------------------------------------------------------------------- SELECT * FROM [sample_data] WHERE [val] LIKE 'ab%' ; SELECT * FROM [sample_data] WHERE [val] LIKE 'a%c' ; SELECT * FROM [sample_data] WHERE [val] LIKE 'a_c' ; SELECT * FROM [sample_data] WHERE [val] LIKE 'a[bt]c' ; SELECT * FROM [sample_data] WHERE [val] LIKE 'a[^bt]c' ;
run
|
edit
|
history
|
help
0
quan ly chuyen bay
student
tFuncionario
function used in cte
Viernes
Many-to-Many Join Example
reee
Dbms_20181cse0068
/Users/svetlanakanevskaa/Downloads/ACDB_LIGHT_MS.sql
table creation