For MySql Let us assume a Customers table with a CustomerName Column which contain string of Max Length 200. For Sql Server Let us assume a Customers table with a CustomerName Column which contain string of Max Length 200.
Category: MySql
Find users within a distance by using Latitude, Longitude, and MySQL
For filter records, you need to latitude and longitude column in the table which you are using. For fetching data as per the lat-long you can use below query by passing latitude and longitude values in the comments. In this…
How To Select Different Column of data as one with Laravel and MySql?
Laravel uses query builder to perform database operations so you don’t need to rewrite the query for different database Platform. Let us assume a table with three column called cert1, cer2 and cert3 First we need to select the column…