Title: Support MYSQL functions?
Last modified: August 22, 2016

---

# Support MYSQL functions?

 *  Resolved [karthikreddy442](https://wordpress.org/support/users/karthikreddy442/)
 * (@karthikreddy442)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/support-mysql-functions/)
 * Hi,
 * Does the MYSQL query support the substring and concat function of MYSQL?
    I am
   trying to insert substrings of 3 entries in the database as an entry into a column.
 * INSERT INTO COURSE_REVIEW (`REVIEW_ID`, `COURSE_COMBINATION`, `COMBINATION_REVIEW`,`
   COMBINATION_RATING`) VALUES (“{2}”, CONCAT(SUBSTRING({6},1,8),SUBSTRING({6},1,8),
   SUBSTRING({6},1,8)), “{5}”, “{2}”)
 * [https://wordpress.org/plugins/form-maker/](https://wordpress.org/plugins/form-maker/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Contributor [webdorado](https://wordpress.org/support/users/webdorado/)
 * (@webdorado)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/support-mysql-functions/#post-5934076)
 * Dear karthikreddy442,
 * This should work, but use the query below during the process:
 * INSERT INTO COURSE_REVIEW (REVIEW_ID, COURSE_COMBINATION, COMBINATION_REVIEW,
   COMBINATION_RATING) VALUES (“{2}”, CONCAT(SUBSTRING(“{6}”,1,8),SUBSTRING(“{6}”,
   1,8),SUBSTRING(“{6}”,1,8)), “{5}”, “{2}”)
 *  Thread Starter [karthikreddy442](https://wordpress.org/support/users/karthikreddy442/)
 * (@karthikreddy442)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/support-mysql-functions/#post-5934124)
 * Hi thanks for the quick reply:
 * One more question I have is what is the best way to display information from 
   the database on a page?
 * Is there a way to set form action= *.php to call the php on user hitting submit?
 *  Plugin Contributor [webdorado](https://wordpress.org/support/users/webdorado/)
 * (@webdorado)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/support-mysql-functions/#post-5934126)
 * Dear karthikreddy442,
 * We do have only front-end submission display option with the Form Maker available
   with the Pro version. This will though display all submitters’ data. There is
   no other easy way of displayig the submissions on the front end. Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Support MYSQL functions?’ is closed to new replies.

 * ![](https://ps.w.org/form-maker/assets/icon-256x256.png?rev=2068681)
 * [Form Maker by 10Web - Mobile-Friendly Drag & Drop Contact Form Builder](https://wordpress.org/plugins/form-maker/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/form-maker/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/form-maker/)
 * [Active Topics](https://wordpress.org/support/plugin/form-maker/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/form-maker/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/form-maker/reviews/)

## Tags

 * [function](https://wordpress.org/support/topic-tag/function/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 3 replies
 * 2 participants
 * Last reply from: [webdorado](https://wordpress.org/support/users/webdorado/)
 * Last activity: [11 years, 2 months ago](https://wordpress.org/support/topic/support-mysql-functions/#post-5934126)
 * Status: resolved