faqts : Computers : Databases : MySQL : Language and Syntax

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

10 of 13 people (77%) answered Yes
Recently 6 of 8 people (75%) answered Yes

Entry

How to search a kewyword in (row1) song_artist, and (row2) song_title?

Oct 9th, 2000 21:51
Narendra Jain, Yvo SChaap,


Use the Select command as:
select song_id
from song_master
where song_artist like "%$search_string%"
or song_title like "%$search_string%";