将值与mysql中表的所有字段进行比较
问题描述:
我有一个名为 info_acc (id,state,country,zip) 的表,现在我需要将一组关键字与该表的所有字段进行比较,说值是阿拉斯加我需要将其与 id,state,country 进行比较,zip 并与任何文件匹配,然后将选择行.我怎样才能以有效的方式做到这一点?谢谢
I ahve a table called info_acc (id,state,country,zip) now i need to compare a set of keywords with al the fileds of this table say value is Alaska I need to compare this with id,state,country,zip and in match with any filed then row(s) will be selected. How can I do this with efficient way? Thanks