MySQL Substring Captures all but the last three characters

Question

Basically, I'm trying to find the inverse of this command: substring(term, -3) .

+4

Spencer Oct 14 '11 at 16:21

3 answers

This should do it: SELECT SUBSTRING(term FROM 1 FOR LENGTH(term)-3)

+2

Dvir azulay Oct 14 '11 at 16:25

If you need to match it by comparison, you can use

 WHERE somefield LIKE 'term___'

-1

bscoder Mar 08 '13 at 23:08

Abe miessler · Accepted Answer · 2011-10-14T16:27:27+0000

Try the following:

 SELECT SubStr(myColumn, 1, LENGTH(myColumn) - 3) FROM MyTable

or

 SELECT LEFT(myColumn, LENGTH(myColumn) - 3) FROM MyTable