Monthly Archive: March 2014

Mar 17

php array

What is an Array? An Array is variable which hold more than one value at a time. If you have many value in a single category and looking for a value from category then you can create the array of this category and using loop you can find easily. You can create array using array …

Continue reading »

Mar 02

Fulltext Search in mysql

full

Mysql has supported FULLTEXT Index with VARCHAR and TEXT data type that have been indexed fulltext can be used with special SQL statements that perform the full text search. FULLTEXT Indexed contain multiple columns. In FULLTEXT indexed you can search using MATCH and AGAINST Statements. MATCH MATCHtakes a comma-separated list that names the columns to …

Continue reading »

Mar 02

How to split string in mysql

substr1

Mysql has substring function which returns a specified number of characters from a particular position of a given string. Example : SUBSTRING(string, position, length) String : A string value Position : Starting position Length : Length in Characters mysql query : Select SUBSTRING(‘learning is good practice’,1,8); Mysql also has function SUBSTRING_INDEX function which split the …

Continue reading »

» Newer posts