Hi,
I've the below mysql query. I would like to search for a particular keyword in the tables without giving column names in where clause. Can i do that?

Code:
Select TTT.*,stream_id,stream_name,stream_prgm_count,stream_location,stream_mux_bitrate,stream_size,stream_packet_size,stream_type from 
(Select TT.*,pcr_sid,pcr_prgm_num,pcr_pid from (Select *,case when audio_sid is NULL then video_sid ELSE audio_sid END as SID,case when audio_prgm_num is NULL then video_prgm_num ELSE audio_prgm_num END as PRNO 
from (Select  audio_sid,audio_prgm_num,video_sid,video_prgm_num, audio_pid,audio_type,audio_sr,audio_mode,audio_bitrate,exp_aud_result,video_pid,video_type,video_userdata,video_resolution,video_chroma_format,video_aspect_ratio,video_frame_rate,video_bitrate,exp_vid_result from audio a left join video v on(audio_sid=video_sid and audio_prgm_num=video_prgm_num) union 
select audio_sid,audio_prgm_num,video_sid,video_prgm_num,audio_pid,audio_type,audio_sr,audio_mode,audio_bitrate,exp_aud_result,video_pid,video_type,video_userdata,video_resolution,video_chroma_format,video_aspect_ratio,video_frame_rate,video_bitrate,exp_vid_result from video v left join audio a on (audio_sid=video_sid and audio_prgm_num=video_prgm_num))T)TT left join pcr_info p on (TT.SID=p.pcr_sid and TT.PRNO=p.pcr_prgm_num))TTT left join stream s on (s.stream_id=TTT.SID) where stream_name like '%$temp%' order by stream_name