DATABASES ## names & sizes of all connected hard-drives on this version of linux. TIP: goto using these harddrive names

select lines with 'mytext' in files [ back to top

SELECT * FROM mytable WHERE mycolumn IN ('mytext', ## select lines with 'mytext' or 'mysecondtext' or 'mythirdtext', ignore case, in 'mysecondtext','mythirdtext') ## all directories

select line with 'mytext' [ back to top

SELECT * FROM mytable WHERE mycolunm='mytext' ## select line with 'mytext' ignore case. ie: could match MytEXT mytext or MYTEXT etc SELECT * FROM mytable WHERE (mycolumn='mytext') AND ## select line with both 'mytext' aswell as 'mysecondtext' in any order on the (mysecondcolumn='mysecondtext') ## line SELECT * FROM mytable WHERE (mycolumn='mytext') AND ## select line with 'mytext' aswell as 'mysecondtext' on the line (ignore case) (mysecondcolumn='mysecondtext') SELECT * FROM mytable WHERE (mycolumn='mytext') AND ## select line with 'mytext' aswell as 'mysecondtext' aswell as 'mythirdtext' in (mysecondcolumn='mysecondtext') AND (mythirdcolumn = ## any order (ignore case) 'mythirdtext') SELECT * FROM mytable WHERE (mycolumn='mytext') OR ## select either 'mytext' or 'mysecondtext' (mycolumn = 'mysecondtext') SELECT * FROM mytable WHERE mysecondcolumn ## select line with 'mytext' or 'mysecondtext' or 'mythirdtext', ignore case IN('mytext','mysecondtext','mythirdtext') SELECT * FROM mytable WHERE mysecondcolumn IN (SELECT ## select any of the texts in the file 'mylist'. 'mytext' or 'mysecondtext' or mythirdcolumn FROM mysecondtable) --select a list from ## 'mythirdtext' etc TIP: in Windows ensure you run dos2unix on mylist, so Linux mysecondtable ## can read it SELECT * FROM mytable WHERE mycolumn LIKE 'mytext%' ## select line that begin with 'mytext' TIP:may first want to ensure there are no leading spaces SELECT * FROM mytable WHERE mycolumn LIKE 'mytext[A-D]%' ## select line that begin with (range) 'mytextA' or 'mytextB' or 'mytextC' or 'mytextD' SELECT * FROM mytable WHERE mycolumn LIKE '%mytext' ## select line ending with 'mytext' SELECT * FROM mytable WHERE LEFT(mycolumn, ## select line where 'mytext' is before 'mysecondtext', 'mysecondtext' after CHARINDEX(mycolumn, 'mysecondtext')) LIKE '*mytext*' ## 'mytext'

delete lines [ back to top
                                     Types of questions you can answer using the Muppix Toolkit :

Find out how many products you sold in the last month - which products are giving you largest profit margins. detailed information on all your products
Who are your biggest customers
Predictions of sales - Data Analysis can help all departments of your business - understanding the importance of coherent data sets
Instant Custom Relation Management - automatically updated by the most recent documents on the company's network
Extract websites - easily research information from the net, refining the results and display into useable tables/spreadsheet 
Stripping duplicates - Organizing data - representing in databases, spreadsheets.
Extract information from huge data , loosely held in ordinary files
Search hidden files, Find files saved somewhere in the last 2 minutes ( "I've just downloaded a file, I have no idea where it went on my PC" )
Extracting all emails from our entire Clients Projects directory
Search computer programmes: Find which variable/field is actually being used run each transformation  in our code/programmes

 (Help the Ordering process by seeing what gets sold most- Where to place products in shop or website - on order of popularity -
standardize, validate, de-duplicate and cleanse inconsistent or redundant data.

monitor and analyze the performance of data integration processes.

data integration – Data can be extracted from multiple sources, including big data and traditional data stores, integrated together and then flowed directly into reports,

supports the entire big data lifecycle.

 the solution supports all popular big data stores, as well as traditional relational data sources

                                        Data Science & Analytic Services

Muppix Consultancy have extensive Data Mining experience at Blue Chip clients,  offering total solutions by using Logical Data Modeling,  Advanced Data Mining and Business Analysis especially in the Investment Banking Sector.

Most of the worlds' data is unstructured and therefore cannot easily connect with other data. 

Extracting coherent information from unstructured data is clearly a skill that every consultant & business manager needs.

We're Passionate about helping you understand, manage and derive value from your huge unstructured data