CODEWITHSUNDEEP
mysql
vault-boy
vault-boy

Reputation: 523

Same query works different on two different machines

This MySQL query

SELECT id FROM product WHERE title LIKE '%spoon%'

works fine on in MySQL on machine #1 and returns all products with spoon anywhere in the title string

('black spoon', 'teaspoon', 'red spoons')

Some time ago I migrated the whole thing to a machine #2 but the exact same query returns different number of results and from some reason it only returns products with word teaspoons in the title (no eg. black spoon among the results)

Both MySql servers are version 5.0.51a. That particular product table is exactly the same on both machines with all fields the exact same type, length etc.

Any ideas?

Upvotes: 1

Views: 231

Answers (2)

Backleisty
Backleisty

Reputation: 1

I am sure the problem is not in the database engine(you might want to check that (Inno,etc)) or anything like that. Check your connection config files. You might be connecting to a different database.

Upvotes: 0

fdaines
fdaines

Reputation: 1236

do you check if your encoding charset are the same in both databases?

Upvotes: 1

Related Questions