[Solved] SQL trouble with dots in data [closed]

by


Could you use a regular expression to match the URL? You didn’t include the query…

/^(https?:\/\/)?([\da-z\.-]+)\.([a-z\.]{2,6})([\/\w \.-]*)*\/?$/

The above would be a regular expression to match a URL including the https and double forward slash

Numbers, letters, dots, and hyphens are included here.

And in MySQL you could use this to match it:

http://dev.mysql.com/doc/refman/5.1/en/regexp.html#operator_regexp

solved SQL trouble with dots in data [closed]