fenway

Assuming that format is uniform, you can just split on space.

If you ever need to cross clients, then different databases is a royal pain.

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=331154.0

This is quickly become a php issue -- if the mysql issues have been resolved, I'll move the thread accordingly.

You don't need to pass the pretty string and use it in your query -- just have your URL include low & high values, and search those.

Yeah, but that's scary, since you're returning non-aggregated values in the column list, which likely makes them meaningless.

Not if you're using standard common Western character sets, no.

IMHO, over-indexing, either in number or size, is going to be noticeable.

It will be stored if you store it -- but binary data shouldn't be in a database, as a general rule.

You can't use that kind of flow control in an update statement -- you need: editLock = IF( editCount > 2, '1', '0' )

And even so, 1 slow query is worse than 100 instant ones.

Perhaps you're seeing unicode issues.

When you want variable-length BINARY data -- which shouldn't be stored in the DB anyway.

The refman covers it all -- there are dozens of other subtle differences (trimming, index implications, etc.). More importantly, one variable-length column means you can't have any CHAR fields anymore.

I'm not sure I understand why you need to know... unless these two tables were UNION-able.

Not sure where you're pulling those metric from -- 25-50x faster for 8 bytes?

Don't try and make tables "smaller' -- it's just work for no reason.

(2) should be replaced with last-insert-id() -- or whatever the php function from mysqli is called.

Each of your FULLTEXT indexes lists a single column -- your MATCH() lists multiple.

Sounds like you just want to sort() in php.

You can't do a multi-table insert.

You can't mix FULLTEXT indexes -- if you want to search N columns, you'll need an index with N columns.

You need to cross join, one for each of the three conditions.

"display" has nothing to do with mysql.

Weird symbols how?