Using Regular Expressions in MySQL Queries
Here is an example of how you would select data based on a regular expression. SELECT phone FROM table WHERE phone REGEX ‘^[0-9 ]{11,14}$’ = 0 LIMIT 100 The above would show all the phone numbers that are not between 11 and 14 numbers and spaces. SELECT phone FROM table WHERE phone REGEX ‘^[0-9 ]{11,14}$’ [...]
Connecting to MySQL using TCL
So, lately i’ve been playing around with tcl again, and trying to make it work alongside MySQL to store information such as Q auth’s and various other information on users. Its working quite well. We connect to MySQL through TCL using a package called mysqltcl. Here is how I connect: # First we require the [...]