Quick Search:
 
 mySQL: Finding a substring in a string Jump to:  
Category: >> mySQL >> Finding a substring in a string  

<< lastnext >>

Snippet Name: Finding a substring in a string

Description: Easy way to find a substring within a string.

Comment: (none)

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

SELECT name, INSTR(name, ' '), SUBSTRING(name,1,INSTR(name,' ')) 
FROM cia WHERE name LIKE '% %'


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org