compare value with all the fields of a table in mysql

Question

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

use `OR` in the `WHERE` clause. – Dave Morris Jun 03 '11 at 11:35 — Dave Morris, Jun 03 '11 at 11:35

score 0 · Answer 1 · edited May 23 '17 at 11:55

0

Please read the following article:

Using MySQL Full-text Searching

or use stackoverflow:

How to implement a Keyword Search in MySQL?

mysql keyword search

edited May 23 '17 at 11:55

Community

1
1

answered Jun 03 '11 at 12:15

Sascha Galley

15,711
5
37
51

compare value with all the fields of a table in mysql

1 Answers1

Linked