SQL string comparison with postgresql regex functions | Myriam | 2017-08-29 01:27 |
Status: Closed | ||
Hi Jony, Thank you for your reply. For instance, here is typically what I would like to do with SQL in Labkey : * Comparing dates : SELECT mydate FROM mytable WHERE mydate ~ '(\d{2}\/){2}\d{4}' * Comparing strings : SELECT myfield FROM mytable WHERE myfield ~* '[A-Z]\d{5}._[a-z]+' Is it possible to do this or something similar with reports, modules or wiki pages ? For the moment i'm using the alternative of the "LIKE" syntax (WHERE mydate NOT LIKE 'NK/%/%' AND mydate NOT LIKE 'ND/%/%'). I am therefore obliged to know all the possibilities i've to delete with my query. But when these possibilities will are unknown to me in advance, this alternative will no longer help me .. Regards Myriam |
||