Showing posts with label Query. Show all posts
Showing posts with label Query. Show all posts

Saturday, 16 April 2016

MySQL queries

To select records containing a particular string chain:

SELECT * FROM tablename WHERE instr(fieldname, "find this string");

To update text strings in records:

update films set fieldname = replace(fieldname, 'find this string', 'replace found string with this string');

Saturday, 26 June 2010

DNS Queries

One can make a few DNS queries at --> this site

DNSQueries lets you make every needed network test such as domain health tests, DNSBlacklists checks, dns queries, ptr queries, host geographical informations