Sometimes we need to check the existence of a character or sub-string into a string or find the position of a character or sub-string into a string. Javascript provide us a very simple method :
Tag » String
finding values in comma separated string using mysql
Generally, We give the various options of choices to choose on websites in form of checkbox and stores various values of choices in a column of MySQL database as a comma seperated . For example we store user’s preferred hobby in user table’s hobbies(varchar(250)) field(column). Value stored in this field may be like 1,2,5,6,1 or may be ‘sports’,’gardening’,’cooking’,’reading’.
[ Page 2 of 2 ]