MSSQL Regular expression | regular expression sql
![MSSQL Regular expression](https://i.imgur.com/axBPWDg.jpg)
IhavethefollowingREGEX:[-A-Za-z0-9/.]+$Thiscurrentlycheckswhetherthevalueenteredintoatextboxmatchesthis.Ifnot,itthrowsanerror.Ineedtocheckwhetheranythinghasalreadygoneintothedatabasethatdoesntmatchthis.Ihavetired:SELECT*FROM*table*WHERE([url]NOTLIKE[-A-Za-z0-9/.]+$)SELECT*FROM*table*WHEREPATINDEX([-A-Za-z0-9/.]+$,[url])UPDATESoafterabitofresearchIverealisedIdontthinkIcanuseREGEXP.IthoughtIcoulddosomethinglikethis?Itsnotgivingmetheexpectedresultsbutitsrunningunlikeanythingelse.Cananyonespotan...
![MSSQL Regular expression](http://pix1.agoda.net/hotelimages/300/3008492/3008492_17121510550060424840.jpg?s=800x)
I have the following REGEX: [-A-Za-z0-9/.]+$
This currently checks whether the value entered into a textbox matches this. If not, it throws an error.
I need to check whether anything has already gone into the database that doesnt match this.
I have tired:
SELECT * FROM *table* WHERE ([url] NOT LIKE [-A-Za-z0-9/.]+$) SELECT * FROM *table* WHERE PATINDEX ([-A-Za-z0-9/.]+$, [url])UPDATE
So after a bit of research Ive realised I dont think I can use REGEXP.
I thought I could do something like this? Its not giving me the expected results but its running unlike anything else. Can anyone spot anything wrong with it?
SELECT *, CASE WHEN [url] LIKE [-A-Za-z0-9/.]+$ THEN Match ELSE No Match END Validates FROM *table*取得本站獨家住宿推薦 15%OFF 訂房優惠
本站住宿推薦 20%OFF 訂房優惠,親子優惠,住宿折扣,限時回饋,平日促銷
Documentation: 9.5 | regular expression sql
How Regex in SQL works | regular expression sql
How to use Regex in SQL | regular expression sql
How to Use Regex in SQL? | regular expression sql
MSSQL Regular expression | regular expression sql
MySQL 5.5 Reference Manual : | regular expression sql
MySQL 8.0 Reference Manual | regular expression sql
MySQL | regular expression sql
regex in sql | regular expression sql
Regular Expressions in SQL | regular expression sql
Regular Expressions in SQL Server Databases | regular expression sql
SQL Contains String – SQL RegEx Example Query | regular expression sql
SQL RegEx | regular expression sql
sql server | regular expression sql
SQL 語法SELECT REGEXP | regular expression sql
T | regular expression sql
T-SQL Regular expression | regular expression sql
Using RegEx in SQL Server | regular expression sql
[ASP.NET]正規運算式剖析SQL基本指令(Using Regular ... | regular expression sql
使用規則運算式搜尋文字 | regular expression sql
![](https://i.imgur.com/axBPWDg.jpg)