mysql - Get values by comparing comma seperated string -


i have table this.

languages table

id  languages   1   english  2   spanish  3   hindi  4   portuguese 

users table

userid  languages  1421     1,3 1422     2,3,4 

i want output this

userid languages_names  1421    english,hindi 1422    spanish,hindi,portuguese 

thanks in advance.


Comments

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

javascript - Get parameter of GET request -

javascript - Twitter Bootstrap - how to add some more margin between tooltip popup and element -