Fetch all words from column with like I have a column with description and inside it can contain # value . 
what I want is all the words searched from that column with #tag 

This is my query 

SELECT description FROM  photo where description like '%#aw%';


and this is what I get as output 

description
'nice place #awesome'
'my pc #awe'
' nice design #aw'
'my table #awesomedatabase'


and what I want is this output how to modify my query in order to get below output 

 description 
 #awesome
 #awe
 #aw
 #awesomedatabase
You can use the INSTR function of MYSQL to find the starting position of the word matching your delimiter '%#aw%'. And then use sub string to fetch the word of your interest.

for eg. SELECT SUBSTR(description,INSTR (description,'#')) 
FROM photo where description like '%#aw%';

The problem here though is that if the word is followed by anything, it will also be a part of your output. You will need to find the position of the immediate next 'blank space' and use it as the LEN parameter (the 3rd param in SUBSTR function).