How can i use conditional operators with like in my sql query?

Question

I want to count number between say 56,80,95 and 108 from a column of my table where i have stored digits seperated with a ",". Now, I want to count the primary id's of the columns which contains any of the above number using like or some other way. I tried using like as below:

SELECT COUNT(DISTINCT(ID)) FROM TABLE_NAME WHERE COL_NAME LIKE "%56%" OR '%80%'

SELECT COUNT(DISTINCT(ID)) FROM TABLE_NAME WHERE COL_NAME LIKE ("%56%" OR '%80%')

NON OF THIS WORKS

Can you elaborate your question? and from your query I am guessing you have stored the column name with numbers? — ThinkingMonkey
– ThinkingMonkey, Commented Jan 3, 2012 at 10:46
Don't guess, just run select "%56%" OR '%80%'. You'll see it's zero (boolean false). The LIKE operator expects a string, not a boolean. — Álvaro González
– Álvaro González, Commented Jan 3, 2012 at 11:02

Hemant Metalia · Accepted Answer · 2012-01-03 10:45:17Z

3

you can do

SELECT COUNT(DISTINCT(ID)) FROM TABLE_NAME WHERE COL_NAME LIKE "%56%" OR COL_NAME LIKE '%80%'

refer example queries

answered Jan 3, 2012 at 10:45

Hemant Metalia

30.8k18 gold badges77 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1045373 Over a year ago

an d what if have have lot of digits to compare say 50 different digit to compare?? den should i write all the digits as above??

sverdianto · Accepted Answer · 2012-01-03 10:49:06Z

0

SELECT COUNT(ID) FROM TABLE_NAME WHERE COL_NAME LIKE "%56%" OR COL_NAME LIKE '%80%'

Maybe?

answered Jan 3, 2012 at 10:49

sverdianto

1343 bronze badges

Comments

renick · Accepted Answer · 2012-01-03 11:33:43Z

0

SELECT count(*) 
FROM  `table` 
WHERE FIND_IN_SET( col_name,  '56,80,95' );

edited Jan 3, 2012 at 11:33

answered Jan 3, 2012 at 10:58

renick

3,9112 gold badges34 silver badges41 bronze badges

Collectives™ on Stack Overflow

How can i use conditional operators with like in my sql query?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related