Title: Issue using SUBSTRING in sql query
Last modified: August 19, 2016

---

# Issue using SUBSTRING in sql query

 *  [eversonl](https://wordpress.org/support/users/eversonl/)
 * (@eversonl)
 * [15 years, 9 months ago](https://wordpress.org/support/topic/issue-using-substring-in-sql-query/)
 * Hi,
    I am trying to find out if this is a bug worth reporting as it seems a little
   odd.
 * I am trying to put togeter a widget but when testing with my live site i get 
   an issue using the plugin editor.
 * when I use a qry block with `SUBSTRING($x, 1, 1)` The editor bombs out to a webpage
   saying “sorry page is no longer availbale”
 * When I use `SUBSTR($x, 1, 1)` its fine.
 * On my local Wamp setup it doesn’t care which one I use.
 * Any one have any thoughts?

Viewing 1 replies (of 1 total)

 *  [Mark / t31os](https://wordpress.org/support/users/t31os_/)
 * (@t31os_)
 * [15 years, 9 months ago](https://wordpress.org/support/topic/issue-using-substring-in-sql-query/#post-1632428)
 * Can i see more of the query code please, the whole query line would be most helpful.

Viewing 1 replies (of 1 total)

The topic ‘Issue using SUBSTRING in sql query’ is closed to new replies.

 * In: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/)
 * 1 reply
 * 2 participants
 * Last reply from: [Mark / t31os](https://wordpress.org/support/users/t31os_/)
 * Last activity: [15 years, 9 months ago](https://wordpress.org/support/topic/issue-using-substring-in-sql-query/#post-1632428)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics