Mysql query optimizations in where clause

| posted in: MySql | 0

Summary: Iam listing some of the points to optimize mysql query : These are things we need to remember while writing the queries . Removal of unnecessary parentheses: ((a AND b) AND c OR (((a AND b) AND (c AND … Continued

Boolean Full-Text Searches

| posted in: MySql | 0

Summary: MySQL can perform boolean full-text searches using the IN BOOLEAN MODE modifier. With this modifier, certain characters have special meaning at the beginning or end of words in the search string. In the following query, the + and – … Continued

Mysql String Functions

| posted in: MySql | 1

Summary: ASCII() Return numeric value of left-most character BIN() Return a string representation of the argument BIT_LENGTH() Return length of argument in bits CHAR_LENGTH() Return number of characters in argument CHAR() Return the character for each integer passed CHARACTER_LENGTH() A … Continued

Delete Duplicate from MySQL Table

| posted in: MySql | 0

Recently in many projects, we got the problem of data being duplicated in many table, such as cities for FFC, login log in Connected living and so on. In this post I am going to demonstrate you with example, how … Continued

Doctrine Delete, Update Issue

| posted in: MySql | 0

Summary: Whenever we are Editing or Deleting a record using doctrine query, If the where condition primary key is null or empty. It is deleting/updating¬† all the records from the table. lets take the following example sql query: delete from … Continued