Finding a value in several fields

Question

Navigation

#1 by (4 votes)
#2 by (3 votes)

2

In my bank I have 3 columns for phone, I need to know if the value is in any of the 3 fields, what is the best way to assemble this select?

sql sql-server

asked by anonymous 07.01.2015 / 20:52

2 answers

score 4 · Answer 1

4

You can use a IN "reverse" (than is normally used):

... WHERE '2345-6789' IN (tel1, tel2, tel3)

07.01.2015 / 21:01

score 3 · Answer 2

If it is a non-exact search, ie by numbers that contains a portion of the phone, you can do this:

WHERE telefone1 like '%123%'
    OR telefone2 like '%123%'
    OR telefone3 like '%123%'

Being 123 the number entered by the user in the search field.