Finds table names in table list and subqueries. Table names are in group #1 of all matches One note. In case of table list (like SELECT * FROM table1, table2, etc) group#1 will contain all tables string (like "table1, table2, etc") so it's necessary to do additional handing like splitting the string

This is loosely based on some other examples, but goes a bit further in terms of what it will and won't match. In particular, it matches IPv6 addresses like ff02::, ff02:1000::, and (the syntactically valid but improbable) ::0001:0002

Use with csv with ";" delim. Matches values that contains carriage return not surrounded by double quotes.

Match only first occurrence of word in a line.

password con 8

Searches for credit card numbers from MasterCard or visa

For use on wordpress on multisite. Finds mp4 videos within the content.

Matches publicly available IPv4 addresses (excludes 10., 172.16-32, and 192.168 blocks).

Detects almost all URLs contained in a sentence

removes divs of the print class

Match any IP adress or Subnet masks and split all bytes in capture groups

match any type of url and split each part (protocol, domain, page, GET, and ID) in capture groups

You see how it matches the hit ratio line? Yeah m8, that simple

for finding user mentions in markdown-like comments