RSS

Get Document Extension in Mysql

13 Jun

you have no need to save extension in database of uploaded document or images.you can get in select statement

 

select tblscandocument.*, (substring(scandocuments,LOCATE(‘.’,scandocuments)+1,length(scandocuments))) as documenttype from tblscandocument

 

 

Advertisements
 
Leave a comment

Posted by on June 13, 2012 in My SQL

 

Tags: ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: