Compare MySQL Versions

[JasonLewis]

What I'm attempting to do is compare versions of MySQL. I couldn't find any reference to a default PHP function, although I was thinking of using PHPs version_compare(), and just throwing in the MySQL Version number as the first parameter. What I'm unsure of is that MySQL version numbers are different. They have versions like 5.1.36.

 

So, for example:

 

5.1.36 < 5.1.4 (true, if I use version_compare it says false)

 

Unless 5.1.4 is really 5.1.04. I'm just not 100% on how MySQL does its version numbering. I was beginning to write a function that compared version numbers, but if I can use version_compare() then I will.

 

Cheers.

[JasonLewis]

Just for reference for those interested.

 

I was just unaware of how version numbers work. MySQL uses the M.m.r numbering system.

 

M = Major

m = minor

r = revision

 

So in conclusion, you can use version_compare to compare MySQL Versions.