ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Scripts  >>  PHP
 
 


 

 
 PHP interview questions  PHP Interview Questions
 ASP interview questions  ASP Interview Questions
 CGI Perl interview questions  CGI Perl Interview Questions
 JavaScript interview questions  JavaScript Interview Questions
 VB Script interview questions  VB Script Interview Questions
 JSP interview questions  JSP Interview Questions
 Shell Script interview questions  Shell Script Interview Questions
 Python interview questions  Python Interview Questions
 Tcl interview questions  Tcl Interview Questions
 Awk interview questions  Awk Interview Questions
 AJAX interview questions  AJAX Interview Questions
 Ruby on Rails interview questions  Ruby on Rails Interview Questions
 Scripts AllOther interview questions  Scripts AllOther Interview Questions
Question
What is fulltextsearch
 Question Submitted By :: Rohit Singh
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is fulltextsearch
Answer
# 1
MySQL has support for full-text indexing and searching. A 
full-text index in MySQL is an index of type FULLTEXT. 
FULLTEXT indexes can be used only with MyISAM tables; they 
can be created from CHAR, VARCHAR, or TEXT columns as part 
of a CREATE TABLE statement or added later using ALTER 
TABLE or CREATE INDEX. For large datasets, it is much 
faster to load your data into a table that has no FULLTEXT 
index, and then create the index afterwards, than to load 
data into a table that has an existing FULLTEXT index. 

Constraints on full-text searching are listed in Section 
12.7.4, “Full-Text Restrictions”. 

Full-text searching is performed with the MATCH() function. 

mysql> CREATE TABLE articles (
    ->   id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY 
KEY,
    ->   title VARCHAR(200),
    ->   body TEXT,
    ->   FULLTEXT (title,body)
    -> );
 
Is This Answer Correct ?    1 Yes 0 No
Jagpreet
 

 
 
 
Other PHP Interview Questions
 
  Question Asked @ Answers
 
What are the different methods of passing data or information between two calls of a web page? What are the advantages/disadvantages of these methods? Patni2
Which of the following represents the proper way to set a session variable? Answer: a. $_SESSION['foo'] = 'bar'; b. session_start(); c. session_set_save_handler ('myopen', 'myclose', 'myread', 'mywrite', 'mydelete', 'mygarbage'); d. $foo = $_SESSION['foo']; 2.When administering MySQL, you should make the data directory accessible via the operating system 3.which statement can be used to determine how the optimizer resolves a query TCS7
display selected value in dropdown list through javascript without page refresh  1
How can we encrypt the username and password using PHP? Rushmore-Consultancy1
What is the difference between the functions unlink and unset? TCS2
What is the different between cookies and session in php?  6
How to install PHP with --mcrypt and --mhash?  1
If i make my selection in State Dropdown list, i would the City and ZipCode dropdown list to be automatically reupdated based on the State i select.(This to avoid the user select a City or Zipcode that does not correspond to the State previously selected.)  1
is 'easyphp' is compelete technology to design a phpmysql site?  3
How to get seconds from current date using date function ? Satyam1
What are the difference between abstract class and interface?  3
What is meant by urlencode and urldocode?  1
what is interface in java.  4
What is the difference between $message and $$message?  2
How can we destroy the cookie?  2
What is The difference between ' and " where they can ben in between or outmost and how Avis-Software2
does current version of mysql (myisam) supports foreign keys ?  1
Whats the difference between include() and require()?  3
just explain MYSql ISAM and InnoDB functions. and what is the diffrent between both. and which is the better in both.  2
How can I reverse sort an array keeping the correlation between the index and value? Rushmore-Consultancy1
 
For more PHP Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com