Mysql tips & functions

Mysql tips & functions

http://zetcode.com/databases/mysqltutorial/functions/

http://www.barattalo.it/2012/10/19/13-mysql-tips/

http://net.tutsplus.com/tutorials/other/top-20-mysql-best-practices/

Interesting Mysql Functions “Left” and “instr”

url => http://example.com/dev/php/code
required result => code

sql would be => select reverse(left(reverse(url), instr(reverse(url),’/’) -1)) from table where ..

result would be=> code

it produces the reverse of left first string from the deliminator

——————————————————————-

find_in_set mysql:

http://www.bytestechnolab.com/blog/2011/12/05/find_in_set-mysql-function-comma-sperated-search/