MySQL Forums
Forum List  »  InnoDB

Selecting first alphabet from the row
Posted by: jamil Ahmad
Date: January 02, 2009 01:14PM

how can i make the select query to get the first alphabet in the string. actually 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 --- @Vjameel
5 --- %sjohn
============================
i want to fetch only that rows whos first alphabet is v ommitting anything(special characters,numeric values) before that message
hope that this will clear my question
in my string there may be any special characters also like "%&#V jameel"
so in this case i want to fetch the V.

Thanks in advance

Options: ReplyQuote


Subject
Views
Written By
Posted
Selecting first alphabet from the row
4028
January 02, 2009 01:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.