Featured
-
No Featured Found!
Tags
How to use LIKE operator in MySQL
Hi Reader's,
Welcome to FindNerd, today we are going to discuss how to use LIKE operator in MySQL?
Basically, LIKE operator is used for searching for a specified pattern in a column. So in other words we can say that the LIKE operat...
How to pass mulitple values to update records with a single query
Hello Readers if you want to update mulitple record by multiple id, then you have to use in clause in MySql
Lets see the example as below:-
$ids = array(474,25, 99,101);
Here I have an array $ids with multiple id's. Now this array w...
MYSQL, PHP :- Query Concatenating Fields To Make Date And Running Between Query On It
Recently, I faced a problem when the date was saved in different fields month, year and date. I need to club all these fields together and run a between query on it.
Another issue which was there was that Date has '0' contacted if the value ...
How to delete duplicate rows in a table set MySql
Hello readers!. If you having the much of redundant/duplicate data growing in your database you can delete it with just a single query as I wrote here.
Let say I have a table Address and want to delete the all the duplicate records whose city...
Indexed full text search in PHP-MySQL (PART - 2)
We already discussed Natural full text search in Indexed full text search in PHP-MySQL (PART - 1).
Lets look into Boolean Full Text Search.
In this we can use various operators to change the behavior of search. To specify a search to be b...
Indexed full text search in PHP-MySQL (PART - 1)
We need to write search queries every now and then in our projects. This is one of the most common tasks a PHP developer has to do. Most of the developers still use wildcard queries for this purpose which is very slow in searching records. Howeve...
How to optimize and repair all databases and tabels in mysql?
Optimization of database tables in mysql is a methodology which must be done frequently to make your database healthy.
As per mysql manual,
OPTIMIZE TABLE should be used if you have deleted a large part of a table or if you have made ...
