Category: >> mySQL >> Extract part of a string Bookmark and Share

<< lastnext >>

Snippet Name: Extract part of a string

Description: How to extract/select just part of a string.

Comment: (none)

Author: CoderZone
Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 01st, 2009

SELECT name, SUBSTRING(name,4,2) 
FROM events WHERE event = 'violation'
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© | users online: 6