findTableDataContainingWords.html

<label for="tb">Console<br/><textarea id="tb" style="height:500px;width:500px;"></textarea></label>

<script>
	function printNl(text){
    	var tb = document.getElementById("tb");
        if(tb){
        	if(typeof(text) === 'object'){
            	text = JSON.stringify(text);
            }
        	var currentVal = tb.value;
            if(currentVal === ''){
            	currentVal += text.toString();
            }else{
            	currentVal += '\r\n' + text.toString();
            }            
            tb.value = currentVal;
        }
    }
    
    let tbl = {
    	tableName: '',
        fields: [
        'ID', 
        '', 
        ''
        ],
        excludeFields: ['ID'],
        words: ['test', 'Test']
    }
    
    function generateTopTen(){
    	printNl('SELECT TOP 10 * FROM ' + tbl.tableName);
    }
    
    function generateFindWithWords(){
    	tbl.fields = tbl.fields.filter(Boolean)
    	var selector = '';
        tbl.fields.forEach(function(word, index){
        	if(word !== ''){
            	selector += word;
            	if(index < tbl.fields.length-1){
            		selector += ', ';
            	}
            }
        });
    	printNl('SELECT '+selector+' FROM ' + tbl.tableName);
        
        var where = ''; 
        if(tbl.fields.length > tbl.excludeFields.length){
        	where = 'WHERE '
        }
        tbl.fields.forEach(function(field, wordIndex){
        	let clause = '';
            let exclude = tbl.excludeFields.includes(field) || field === '';
        	if(!exclude){
            	tbl.words.forEach(function(w, wIndex){
                	clause += (field + " LIKE '%" + w + "%'")
                    if(wIndex < tbl.words.length-1){
            			clause += ' OR ';
                    }
                });
            }
            
            if(wordIndex < tbl.fields.length-1 && !exclude){
            	clause += ' OR ';
            }
            
            if(!exclude){
            	where += clause + '\n';
            }
            
        });
        
        printNl(where);
    }
    
    generateTopTen();
    generateFindWithWords();
    
    
</script>