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 gkittelson 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

    thanks for your reply actually i want to make the select query to get the first alphabet in the string.i have a table for voting messages(msgid(int),message(varchar)) data in the table is as follows msgid message ========= ======= 1 v jameel 2 vjohn 3 $/vjohn 4...
  2. 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
  3. jamiljarrar1

    selecting first alphabet in the string

    thanks pwise for your kind reply. actually i have a table for voting messages(messageid(int),message(varchar)) data in the table is as follows messageid message ========= ======= 1 v jameel 2 vjohn 3 /vjohn 4...
  4. 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