Using Mysql function to realize code _MYSQL for judging video extension

Copy Code code as follows:

Delimiter | |

DROP FUNCTION IF EXISTS is_mobile| |
CREATE FUNCTION is_mobile (x VARCHAR (255)) RETURNS TINYINT (1)
BEGIN
DECLARE result TINYINT (1) DEFAULT 0;
SET x = LCASE (x);
IF Right (x,4) = '. mp4 ' THEN
SET result = 1;
ELSEIF Left (x,9) = ' [Ctvideo] ' THEN
SET result = 1;
End IF;
return result;
End;

delimiter;

Note:
This method has a scenario that I use to make a mark in the Sphinx index such as:

SELECT is_mobile (' Http://www.jb51.net/demo/test.mp4 ') as M
If the use of a large number of front-end, will increase the pressure of MySQL, the proposal or the script to complete.
I personally also only a temporary solution, later will be upgraded by the way the system to complete the program.