Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jamiljarrar1

    converting MS Sql server query to mysql query

    hi all what will be the mysql equivalent of the following query as PATINDEX is not used by mysql select * from table1 where substring(msg1, PATINDEX ('%[a-zA-Z]%',msg1),1) = 'v' as msg1 is my column name and v could be in upper case thanks in advance
  2. jamiljarrar1

    selecting first alphabet in the string

    how can i make the select query to get the first alphabet in the string. for example my string look like as "#@$%/;Please Help me" i want to get the first alphabet 'P'. I dont want any thing before 'P'. Advance Thanks for your help

Part and Inventory Search

Back
Top