remove after certain character in MYSQL field data

/* the following query will check “@” character in specified [FIELD_NAME].
* Suppose you want to remove all the character after @ from a field name.
* Suppose you have email addresses like rajan@rajanmaharjan.com.np, pasha@rajanmaharjan.com.np, john@rajanmaharjan.com.np
* Now you want to have all names and remove all character after @ than you can use following query to extract name to the field “name”
*/

update customer_detail set customer_name=
CASE
when (INSTR(email_address,”@”)>0)
THEN substring(email_address, 1, INSTR(email_address,”@”)-1)
ELSE “no name”
END
*/
update [TABLE_NAME] set [FIELD_NAME]=
CASE
when (INSTR([FIELD_NAME],”@”)>0)
THEN substring([FIELD_NAME], 1, INSTR([FIELD_NAME],”@”)-1)
ELSE [FIELD_NAME]
END

javascript splice similar to PHP splice

/* added by Rajan Maharjan
* @param (array) arrayVar, (string) elementVar
* return (array) arrayVar;
* example : _splice(Array(1,2,3,4,5),4); will return Array(1,2,3,5);
*/
function _splice(arrayVar,elementVar){
//var returnRemovedArray=Array();
for(var p=0;p<arrayVar.length;p++){
if(arrayVar[p]==elementVar){
arrayVar.splice(p,1);
}
}
return arrayVar;
}

/* example goes here */
var newArray=splice(Array(1,2,3,4,5),4);
alert(newArray.join(“,”)); // alerts value 1,2,3,5

javascript in array check

/*
* @params : arrayVar (array) and keyVar to compare with arrayVar
* return : true | false
*/
function inArray(arrayVar, keyVar){
for(var j=0;j<arrayVar.length;j++){
if(jQuery.trim(keyVar)==jQuery.trim(arrayVar[j])){
return true;
exit();
}
}
return false;
}