Assuming you are using MyISAM engine, Execute:

    ALTER TABLE products ADD FULLTEXT(brand);

The fulltext index should contain exactly the same number of columns, in same order as mentioned in MATCH clause.

If you don&#39;t feel like having the columns in the same order as in the match clause( or the same number), you can always use &#39;OR&#39; that is: 

    ALTER TABLE products ADD FULLTEXT(brand);
    ALTER TABLE products ADD FULLTEXT(product_name);

     SELECT * FROM products WHERE MATCH(brand) AGAINST(&#39;+Skoda*&#39; IN BOOLEAN MODE) OR MATCH(product_name) AGAINST(&#39;+productName*&#39; IN BOOLEAN MODE)

When everything was right and still got this error I found that the `KEYS` were disabled. A simple error that is sometimes overlooked:

Make sure you have enabled the keys on that table.

It didn&#39;t work for me when I had disabled the keys. But when I enabled the keys `ALTER TABLE table name ENABLE KEYS;` it worked fine 


I found I also needed to do this on my instance as the index was not visible. It was a checkbox while exploring MySQL Workbench. While invisible the index is not reachable by a query.

    ALTER TABLE products ALTER INDEX brand VISIBLE;

Make sure the table engine is set to MyISAM.

Using IRB, why are the Date &amp; Time classes automatically loaded, but DateTime is not? I have to `require &#39;date&#39;`, this does not make sense to me because I thought that both Date and DateTime were using the standard library `&#39;date&#39;`?

    ruby-1.9.2-p290 :001 &gt; Date
     =&gt; Date
    ruby-1.9.2-p290 :002 &gt; Time
     =&gt; Time
    ruby-1.9.2-p290 :003 &gt; DateTime
    NameError: uninitialized constant Object::DateTime
    	from (irb):3
    	from /Users/kamilski81/.rvm/rubies/ruby-1.9.2-p290/bin/irb:16:in `&lt;main&gt;&#39;
    ruby-1.9.2-p290 :004 &gt; require &#39;date&#39;
     =&gt; true
    ruby-1.9.2-p290 :005 &gt; require &#39;date&#39;
     =&gt; false
    ruby-1.9.2-p290 :006 &gt; DateTime
     =&gt; DateTime

Why is Ruby&#39;s Date class automatically loaded but DateTime is not?

In PHP, what is the difference between `is_null` and `==null` in PHP? What are the qualifications for both to return true?

PHP is_null() and ==null

I&#39;m working with fulltext, I executed an command to add the fulltext index to multiple comments, and returned no errors, then I did:

    SELECT * FROM products WHERE MATCH(`brand`) AGAINST(&#39;Skoda&#39;);

Which is in the brand column - but I get following:

&gt; Can&#39;t find FULLTEXT index matching the column list

Eventho, when my table looks like this:

    FULLTEXT KEY `name` (`name`,`breadcrumb`,`description`,`brand`,`price`,`year`,`km`,`usage`,`type`)

Is it because I should use the `name` instead? to do the search? Or what can be wrong.

Can&#39;t find FULLTEXT index matching the column list (indexes is set)

I'm working with fulltext, I executed an command to add the fulltext index to multiple comments, and returned no errors, then I did:
<pre><code class="hljs language-sql">SELECT * FROM products WHERE MATCH(`brand`) AGAINST('Skoda');
</code></pre>
Which is in the brand column - but I get following:
> Can't find FULLTEXT index matching the column list
Eventho, when my table looks like this:
<pre><code class="hljs language-go">FULLTEXT KEY `name` (`name`,`breadcrumb`,`description`,`brand`,`price`,`year`,`km`,`usage`,`type`)
</code></pre>
Is it because I should use the <code>name</code> instead? to do the search? Or what can be wrong.

I have a `php` application where I want to read data from excel, Insert into database and then generate pdf reports for specific users.
I searched a lot but nothing specific given about both things.


How to use phpexcel to read data and insert into database?

How would I get the first letter of each word for a given string?

    $string = &quot;Community College District&quot;;
    $result = &quot;CCD&quot;;

I found the javascript method but wasn&#39;t sure how to convert it to php.

Get the first letter of each word in a string

I&#39;ve been struggling with this error for a while now.

To start with, I just thought it was white space, but after further research I think it might be a problem similar to this:

&gt; Look for any statements that could send output to the user before this header statement. If you find one or more, change your code to move the header statement before them. Complex conditional statements may complicate the issue, but they may also help solve the problem. Consider a conditional expression at the top of the PHP script that determines the header value as early as possible and sets it there.

I&#39;m guessing the include header is causing the problem along with the header(), but I&#39;m not sure how to rearrange the code to get rid of this error.

How do I remove the error?

    &lt;?php
        $username = $password = $token = $fName = &quot;&quot;;

        include_once &#39;header.php&#39;;

        if (isset($_POST[&#39;username&#39;]) &amp;&amp; isset($_POST[&#39;password&#39;]))
            $username = sanitizeString($_POST[&#39;username&#39;]);

        $password = sanitizeString($_POST[&#39;password&#39;]); //Set temporary username and password variables
        $token    = md5(&quot;$password&quot;); //Encrypt temporary password

        if ($username != &#39;admin&#39;)
        {
            header(&quot;Location:summary.php&quot;);
        }
        elseif($username == &#39;admin&#39;)
        {
            header(&quot;Location:admin.php&quot;);
        }
        elseif($username == &#39;&#39;)
        {
            header(&quot;Location:index.php&quot;);
        }
        else
            die (&quot;&lt;body&gt;&lt;div class=&#39;container&#39;&gt;&lt;p class=&#39;error&#39;&gt;Invalid username or password.&lt;/p&gt;&lt;/div&gt;&lt;/body&gt;&quot;);

        if ($username == &quot;&quot; || $token == &quot;&quot;)
        {
            echo &quot;&lt;body&gt;&lt;div class=&#39;container&#39;&gt;&lt;p class=&#39;error&#39;&gt;Please enter your username and password&lt;/p&gt;&lt;/div&gt;&lt;/body&gt;&quot;;
        }
        else
        {
            $query = &quot;SELECT * FROM members WHERE username=&#39;$username&#39;AND password = &#39;$token&#39;&quot;; //Look in table for username entered
            $result = mysql_query($query);
            if (!$result)
                die (&quot;Database access failed: &quot; . mysql_error());
            elseif (mysql_num_rows($result) &gt; 0)
            {
                $row = mysql_fetch_row($result);
                $_SESSION[&#39;username&#39;] = $username; //Set session variables
                $_SESSION[&#39;password&#39;] = $token;

                $fName = $row[0];
            }
        }
    ?&gt;


Warning: Cannot modify header information - headers already sent by ERROR

If I try this:

    $a = 0;    
    echo $a + ++$a, PHP_EOL;
    echo $a;

I get this output:

    2
    1

Demo: http://codepad.org/ncVuJtJu

###Why is that?

I expect to get this as an output:

    1
    1

###My understanding:

    $a = 0;                    // a === 0    
    echo $a + ++$a, PHP_EOL;   // (0) + (0+1) === 1
    echo $a;                   // a === 1

But why isn&#39;t that the output?

Why is $a + ++$a == 2?

I&#39;m looking for the best way to get the first and the last  day of a last month. I use them for make SQL queries to get stats of last month.

I think that this is the best way, more optimized but not more comprensive, anyone have another way to do the same? 

        $month_ini = date(&quot;Y-m-d&quot;, mktime(0, 0, 0, date(&quot;m&quot;, strtotime(&quot;-1 month&quot;)), 1, date(&quot;Y&quot;, strtotime(&quot;-1 month&quot;))));

        $month_end = date(&quot;Y-m-d&quot;, mktime(0, 0, 0, date(&quot;m&quot;, strtotime(&quot;-1 month&quot;)), date(&quot;t&quot;, strtotime(&quot;-1 month&quot;)), date(&quot;Y&quot;, strtotime(&quot;-1 month&quot;))));

Thanks!!

The best way to get the first and last day of last month?

For some reason MySQL stopped giving access for root. Uninstalled and reinstalled with Homebrew. Fresh install, fresh tables but when I enter

    mysql -u root -p

I get this error:

&gt; Access denied for user &#39;root&#39;@&#39;localhost&#39; (using password: NO)

I reinstalled MySQL five times but it is still asking for a password. How do I fix this?

MacOSX homebrew mysql root password

I have been very excited about MongoDb and have been testing it lately. I had a table called posts in MySQL with about 20 million records indexed only on a field called &#39;id&#39;.

I wanted to compare speed with MongoDB and I ran a test which would get and print 15 records randomly from our huge databases. I ran the query about 1,000 times each for mysql and MongoDB and I am suprised that I do not notice a lot of difference in speed. Maybe MongoDB is 1.1 times faster. That&#39;s very disappointing. Is there something I am doing wrong? I know that my tests are not perfect but is MySQL on par with MongoDb when it comes to read intensive chores. 

&lt;br&gt;
Note:

 - I have dual core  + ( 2 threads ) i7 cpu and 4GB ram
 - I have 20  partitions on MySQL each of 1 million records

**Sample Code Used For Testing MongoDB**

&lt;!-- language-all: lang-php --&gt;

    &lt;?php
    function microtime_float()
    {
        list($usec, $sec) = explode(&quot; &quot;, microtime());
        return ((float)$usec + (float)$sec);
    }
    $time_taken = 0;
    $tries = 100;
    // connect
    $time_start = microtime_float();
    
    for($i=1;$i&lt;=$tries;$i++)
    {
        $m = new Mongo();
        $db = $m-&gt;swalif;
        $cursor = $db-&gt;posts-&gt;find(array(&#39;id&#39; =&gt; array(&#39;$in&#39; =&gt; get_15_random_numbers())));
        foreach ($cursor as $obj)
        {
            //echo $obj[&quot;thread_title&quot;] . &quot;&lt;br&gt;&lt;Br&gt;&quot;;
        }
    }
    
    $time_end = microtime_float();
    $time_taken = $time_taken + ($time_end - $time_start);
    echo $time_taken;
    
    function get_15_random_numbers()
    {
        $numbers = array();
        for($i=1;$i&lt;=15;$i++)
        {
            $numbers[] = mt_rand(1, 20000000) ;
    
        }
        return $numbers;
    }
    
    ?&gt;

&lt;br&gt;
**Sample Code For Testing MySQL**

    &lt;?php
    function microtime_float()
    {
        list($usec, $sec) = explode(&quot; &quot;, microtime());
        return ((float)$usec + (float)$sec);
    }
    $BASE_PATH = &quot;../src/&quot;;
    include_once($BASE_PATH  . &quot;classes/forumdb.php&quot;);
    
    $time_taken = 0;
    $tries = 100;
    $time_start = microtime_float();
    for($i=1;$i&lt;=$tries;$i++)
    {
        $db = new AQLDatabase();
        $sql = &quot;select * from posts_really_big where id in (&quot;.implode(&#39;,&#39;,get_15_random_numbers()).&quot;)&quot;;
        $result = $db-&gt;executeSQL($sql);
        while ($row = mysql_fetch_array($result) )
        {
            //echo $row[&quot;thread_title&quot;] . &quot;&lt;br&gt;&lt;Br&gt;&quot;;
        }
    }
    $time_end = microtime_float();
    $time_taken = $time_taken + ($time_end - $time_start);
    echo $time_taken;
    
    function get_15_random_numbers()
    {
        $numbers = array();
        for($i=1;$i&lt;=15;$i++)
        {
            $numbers[] = mt_rand(1, 20000000);
            
        }
        return $numbers;
    }
    ?&gt;

MySQL vs MongoDB 1000 reads

I have a database with 3 columns: 
  
    id, name, somethingelse  
This table has no index set and i am getting &quot;No index defined!&quot; in phpmyadmin  
id is a 7digit alphanumeric value, unique to each row.  
I want to set Drugid to be the primarykey/index (i dont know the difference if there is one)  
Please explain in detail as i am new to this.  
Thank you.


SQL: set existing column as Primary Key in MySQL

The common method to store images in a database is to convert the image to `base64` data before storing the data. This process will increase the size by 33%. Alternatively it is possible to directly store the image as a `BLOB`; for example:

    $image = new Imagick(&quot;image.jpg&quot;);
    $data = $image-&gt;getImageBlob();
    $data = $mysqli-&gt;real_escape_string($data);
    $mysqli-&gt;query(&quot;INSERT INTO images (data) VALUES (&#39;$data&#39;)&quot;);

and then display the image with

    &lt;img src=&quot;data:image/jpeg;base64,&#39; .  base64_encode($data)  . &#39;&quot; /&gt;

With the latter method, we save 1/3 storage space. Why is it more common to store images as `base64` in MySQL databases?

**UPDATE:** There are many debates about advantages and disadvantages of storing images in databases, and most people believe it is not a practical approach. Anyway, here I assume we store image in database, and discussing the best method to do so.

Storing image in database directly or as base64 data?

I&#39;m preparing to deploy a Rails app on Heroku that requires full text search. Up to now I&#39;ve been running it on a VPS using MySQL with Sphinx.

However, if I want to use Sphinx or Solr on Heroku, I&#39;d need to pay for an add-on.

I notice that PostgreSQL (the DB used on Heroku) has built-in full text search capability.

Is there a reason I couldn&#39;t use Postgres&#39;s full-text search? Is it slower than Sphinx or is there some other major limitation?

Any reason not use PostgreSQL&#39;s built-in full text search on Heroku?

There hasn&#39;t been any books about ElasticSearch (that I know of), and http://www.elasticsearch.org/guide/ seems to contain only references.

Any good beginner&#39;s guide or tutorials, perhaps by examples, to recommend, especially in terms of the different mapping and indexing strategies?

Beginner&#39;s guide to ElasticSearch

I realize that a lot of questions have been asked relating to full text search and Entity Framework, but I hope this question is a bit different.

I am using Entity Framework, Code First and need to do a full text search.  When I need to perform the full text search, I will typically have other criteria/restrictions as well - like skip the first 500 rows, or filter on another column, etc.

I see that this has been handled using table valued functions - see http://sqlblogcasts.com/blogs/simons/archive/2008/12/18/LINQ-to-SQL---Enabling-Fulltext-searching.aspx.  And this seems like the right idea.

Unfortunately, table valued functions are not supported until Entity Framework 5.0 (and even then, I believe, they are not supported for Code First).  

My real question is what are the suggestions for the best way to handle this, both for Entity Framework 4.3 and Entity Framework 5.0.  But to be specific:

1. Other than dynamic SQL (via `System.Data.Entity.DbSet.SqlQuery`, for example), are there any options available for Entity Framework 4.3?

2. If I upgrade to Entity Framework 5.0, is there a way I can use table valued functions with code first?

Thanks,
Eric

Entity Framework, Code First and Full Text Search

I am trying to understand what shard and replica is in Elasticsearch, but I didn&#39;t manage to understand it. If I download Elasticsearch and run the script, then from what I know I have started a cluster with a single node. Now this node (my PC) have 5 shards (?) and some replicas (?). 

What are they, do I have 5 duplicates of the index? If so why? I could need some explanation.

Shards and replicas in Elasticsearch

As I find out, since version 3.8.9, mongoose support full text search. But I can&#39;t find a good documentation for it!&lt;br&gt;
I want to do something like:

    db.collection.ensureIndex(
        // Fields to index
        {
            animal:  &quot;text&quot;,
            color:   &quot;text&quot;,
            pattern: &quot;text&quot;,
            size:    &quot;text&quot;
        },

        // Options
        {
            name: &quot;best_match_index&quot;,

            // Adjust field weights (default is 1)
            weights: {
                animal: 5,  // Most relevant search field
                size:   4   // Also relevant
           }
        }
    )

Can I do it with pure mongoose? Or I have to use some plugin like &lt;a href=&quot;https://www.npmjs.org/package/mongoose-text-search&quot;&gt;mongoose-text-search&lt;/a&gt;? How about without weight?&lt;br&gt;
And how should I do it?

Content Type	Original Author	Original Content on Stackoverflow
Question	LucasRolff	View Question on Stackoverflow
Solution 1 - Php	jerrymouse	View Answer on Stackoverflow
Solution 2 - Php	Chogo	View Answer on Stackoverflow
Solution 3 - Php	karthic	View Answer on Stackoverflow
Solution 4 - Php	jorr-el	View Answer on Stackoverflow
Solution 5 - Php	codeafin	View Answer on Stackoverflow

Can't find FULLTEXT index matching the column list (indexes is set)

Php Problem Overview

Php Solutions

Solution 1 - Php

Solution 2 - Php

Solution 3 - Php

Solution 4 - Php

Solution 5 - Php

PHP is_null() and ==null

Why is Ruby's Date class automatically loaded but DateTime is not?

Attributions