Tag : Numeric



Sql function remove numeric characters from column example

Mysql custom fucntion is a very prety and intresting concept. In this posts i want to create one custom mysql function for remove numeric characters from table field value. this function through you can also remove numeric characters from string in mysql. in following sql query fire in your mysql or mssql database and check how it works. So, lets create function and how to use in select statement in sql query. <strong class="step">Create removeNumber function:</strong> <pre class="prettyprint lang-mysql"> DROP FUNCTION IF EXISTS removeNumber; DELIMITER | CREATE FUNCTION removeNumber( str CH.....

By Hardik Savani | March 12, 2016 | | 1175 Viewer | Category : PHP MySql SQL MSSQL
READ MORE

    How to use groupby having with DB::raw in Laravel Query Builder?

    How to use groupby having with DB::raw in Laravel Query Builder?

    Open Post

    PHP MySQL - Simple Image Gallery CRUD example from scratch

    PHP MySQL - Simple Image Gallery CRUD example from scratch

    Open Post

    Solved Issue - "/usr/bin/env: ‘node’: No such file or directory"

    Solved Issue - "/usr/bin/env: ‘node’: No such file or directory"

    Open Post

    Select box with search option example in Jquery using Chosen Plugin

    Select box with search option example in Jquery using Chosen Plugin

    Open Post

    Laravel 5 notification alert using bootstrap notify plugin example

    Laravel 5 notification alert using bootstrap notify plugin example

    Open Post

    Laravel 5 - Twitter API using thujohn/twitter composer package tutorial

    Laravel 5 - Twitter API using thujohn/twitter composer package tutorial

    Open Post